Excel Heatmaps - 3 Ways to Make Them [Must have for Dashboards] @chandoo_
Excel Heatmaps - 3 Ways to Make Them [Must have for Dashboards]  @chandoo_
Uploaded August 2026 | Updated November 2026, 13 hours ago
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: chandoo.org/wp/wp-content/uploads/2026/08/heatmap-3-ways-demo.xlsx

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


#Excel #dashboards #dataanalytics
Excel Heatmaps - 3 Ways to Make Them [Must have for Dashboards]3 Excel Tricks That Look IMPRESSIVE But Take 30 SecondsAdvanced Excel Charts for Dashboards - Free Masterclass for Data AnalystsGet the TOP Salaries with this Excel FormulaGet Ready for the MOST IN DEMAND Data Analyst Skills in 2025Power BI is NOT Enough! Here’s What You Must Learn in 2025 πŸš€Date Range Overlap in Excel - Adv. Formula Trick πŸ’‘Excel Bar / Column Graph Tutorial + 5 Advanced Tips πŸ“ŠHow to get Excel & MS Office for FREE (Power BI + SQL too)Effortlessly Split Text in Excel: Master Formulas Today!I dont use PIVOT tables anymore... I use this other thing instead!How to Find the Next Monday in Excel Fast!
Chandoo |

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

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER