Create A Heat Map Using Conditional Formatting In Excel – Powerful Data Visualisation Tool
We set up a heat map using conditional formatting in Excel. A heat map is a powerful data visualisation tool where values are formatted by colour. In our example we are comparing the average temperatures for January to December across six years. By applying a heat map we can quickly identify the variations in temperature. We will also cover how to hide the numbers and show just the colours and how to vary the colour formats.
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Create A Heat Map Using Conditional F...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
Create Heat Map: (0:55)
Custom Colour Format: (1:40)
Hide Values: (2:23)