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
