Excel Heatmaps - 3 Ways to Make Them [Must have for Dashboards]
By Chandoo
Community Score: 50% | 67 views | 3d
0 community ratings: null thumbs up, null thumbs down
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
Tags: chandoo, chandoo.org, Excel, spreadsheets, Excel heatmaps, conditional formatting Excel, Excel dashboard design, Excel data visualization, create heatmaps in Excel, Excel tutorial for data
More from Chandoo
- 20 AI Terms Explained in Plain English in 20 minutes 🕓 — Score: 50%
- Learn Advance Excel Formulas in an Hour - FREE Masterclass — Score: 50%
- 5 HR KPIs Every Analyst Needs to Master #HRAnalytics #KPIs — Score: 50%
- This simple Excel trick saves me hours on MIS reports 💡 — Score: 50%
- End to End Power Query Data Cleaning Masterclass [FREE Workbook] — Score: 50%
- Here is why I think Excel skills are still relevant in the age of AI — Score: 50%