Welcome to YTUnity

One free SpiderTaz Network account works across every network site.

Excel Heatmaps - 3 Ways to Make Them [Must have for Dashboards]

Chandoo Guide 3 months ago

Description

It's hot 🥵 it's cold🥶, it's just a dashboard that is bold

In this video, let me share 3 powerful and amazing ways to create heatmaps in Excel. We can use them to visualize matrix (pivot) style data for dashboards or MIS reports.

In the video:
0:00 - Introduction to Excel Heatmaps
0:24 - Heatmap 1 using Conditional Formatting
3:16 - Heatmap 2 using Images in Cell
9:34 - Heatmap 3 using bubble chart in Excel
15:29 - In conclusion

You will also learn how to use new PIVOTBY function in the video.

Sample file: https://chandoo.org/wp/wp-content/uploads/2026/08/heatmap-3-ways-demo.xlsx

Related videos:
Map chart in Excel - https://youtu.be/qNNn5uiZxOE
Variance chart in Excel - https://youtu.be/REpNnsdHxlY
Dynamic chart with Check boxes - https://youtu.be/L3WFN0bGv8I
How to add avg. line to Excel charts - https://youtu.be/S2RRGqR_MNw


#Excel #dashboards #dataanalytics

Featured creators

Creators on the SpiderTaz Network

Become a creator →