Share via

Create a unique heat map

Anonymous
2022-05-04T04:38:22+00:00

I'm trying to create a heat map of data which is fed from a pivot table, but not just through conditional formatting of that data. We're creating a floor plan in excel, like the image copied below. These numbers will correspond to numbers in the pivot table, with various sources of data in the same rows (various measures of business performance).

What we want to do is for it to look like this:

So basically using the conditional formatting function on this individual numbers, but using the data to identify how to format it based on corresponding data from elsewhere.

I feel like there is a solution for this, but could do with being pointed in the right direction!

Thank you.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-05-05T00:50:27+00:00

    Re: "We want to show visually which house is doing well"

    It appears your task could be simple.

    Providing the cells are filled with numeric values then using the built-in

    conditional formatting "Color Scales" just might work...

    The image below was achieved in two separate steps.

    Selecting the first group of cells and clicking the top right icon.

    Selecting the 2nd group of cells and clicking the icon to the left of top right.

    Change the numbers and the colors change.

    '---

    (this afternoon got a 10% rent increase notice taped to my door -

    was that you?) <grin>

    '---
    Nothing Left to Lose

    https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

    (free excel programs)

    0 comments
  2. Anonymous
    2022-05-04T23:13:29+00:00

    Thanks for the reply. To provide some context, let's say each of those represented a house...and the income for those houses changed each day/week/month based on refreshing a pivot table. We want to show visually which house is doing well, without them having to look at all of the specific data, so to speak.

    0 comments
  3. Anonymous
    2022-05-04T05:18:09+00:00

    Re: Unique Heat Map

    What you want is not a heat map.
    It appears you want to color specific cells according to some hidden criteria.
    That should be doable (with vba), but I am guessing your criteria changes frequently.

    (that would make it harder to accomplish)

    It seems Conditional Formatting would require new rules every time your criteria changed.

    My home grown heat map for Red to Blue

    '---

    Nothing Left to Lose

    0 comments