Visualizing Your Data With Heat Maps

Work Smarter Not Harder

If you subscribe to these tips, you should already know that people can interpret visual information faster and more easily than text and numbers. Even if you’re dealing with a table of numbers there are ways to present them visually. Depending on your context, charts are often a great option. For those times when seeing all the data and actual numbers is important you might want to consider a heat map.

A heat map is a graphical representation of data where the individual values contained in a matrix are represented as colors.

Fortunately, Excel’s conditional formatting feature makes this super quick and easy. (We love that!)

Let’s take a look at how easy this is by starting with a typical table of Excel data:


To turn this into a heat map, select the range of data and go to the Conditional Formatting button on the Home Ribbon. From there, find the

View original post 127 more words