Excel for Data Analysis and Visualization

Create heat maps in Excel

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

This lesson covers a popular means of visualising data using heat maps. Typically a colour gets darker or lighter depending on the underlying numbers.

Below a matrix of information showing the repayments on a mortgage bond given different interest rates and repayment terms. Which is best and which is worst? A matrix is difficult for a human to look at.

Create heat maps in Excel

As shown below, it becomes easy when you use the Color Scales to generate a heat map. Notice how easy it is to now see where the big and small numbers are and what the trends are.

Create heat maps in Excel

To see the full course contents click here.

0 of 141 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop