• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is there a way to create a heat map that will automatically update?

J

JuliusV

Member
Hi Everyone,

I was wondering is there a way to create a heat map that is of matrix form that will automatically update each time the master spreadsheet numbers are modified?

Additionally, is there a way to have all key statistics and tables on one page so that when one update is made I can readily see all the stats one one page? Currently, I am linking all the information to pivot tables.

Best,

JuliusV
 
For the heat map, you can apply a conditional format using one of the color scales. As the numbers change, colors would also change accordingly.

For the 2nd, what you have described is commonly known as a dashboard. Thankfully, Chandoo has many wonderful examples to learn from:
http://chandoo.org/wp/search/?q=dashboards
 
You must log in or register to reply here.
Back
Top