Heat Maps in Excel


A heat map is a graphical representation of data where the values taken by a variable in a two-dimensional map are represented as colors.

A neat example of a heat map constructed in Microsoft Excel can be seen below:

The above diagram represents different categories on the Y-axis with the total revenue for each device being located at the very right of the table.

The X-axis contains the revenue sales for each device per month with the total revenue for each month aggregated at the bottom of the table .

The size of the bubbles determines how large the revenue was for each device for each particular month. For example we can clearly see that the “Software” category has the largest sales figure compared to the rest.

The different green shades represent the discount rate given. For example a bubble with a light green color had a low discount (e.g. “Laptops) whereas a bubble with a dark green color had the highest discount (e.g. the “Accessories” category). 

To read an informative tutorial on how to construct this heat map in Microsoft Excel visit this
external link.

Feel free to use our contact form if you would like us to build a heat map for your data.