From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Heat maps

Heat maps - Microsoft Excel Tutorial

From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Start my 1-month free trial Buy for my team

Heat maps

“

- [Instructor] Okay, next up, I want to talk about a type of data visualization that's a little bit different. In this case, we're talking about heat maps that are built using cell formatting as opposed to traditional chart types. So, heat maps, in this sense, are commonly used for visualizing trends or relationships simply using color scales. So, some good examples might be accident rates by time of day or day of week, which is what we're looking at here on the bottom screenshot, or average temperature by city, by month, which we're looking at here on the top screenshot, or anything, really, like average sentiment by hashtag. Anything that has values that can be captured with some sort of a color scale could potentially be visualized with a heat map. So, a couple pro tips here. The first, use intuitive color scales, so things like red to green when you're talking about bad or good outcomes, or red to blue if you're talking about hot and cold. And one little tip here that I actually…

Contents