Challenge creating heat map-data carries there own unique values

[Corried]

Hello Excel World.


I'm in the process of creating a 3-Color Scale "Heat map", using conditional formatting for investment purposes.

But I am having some challenges in creating the heat map, because each data carries there own unique values and may differ extremely from each other.

See Link below, of countries listings and the values outline under the header "LAST"

Consumer Confidence - Countries - List

This page displays a table with actual values, consensus figures, forecasts, statistics and historical data charts for - Consumer Confidence. This page provides values for Consumer Confidence reported in several countries. The table has current values for Consumer Confidence, previous releases...

tradingeconomics.com

I also thought with myself. If the heat map should work effectively, each value or each cell reference should have there own heat map values.

But what is the effective way in creating these values or heat map ratio.

See link below of one of the example given.

Albania Consumer Confidence

Consumer Confidence in Albania decreased to -27.61 points in February from -26.82 points in January of 2024. This page provides - Albania Consumer Confidence - actual values, historical data, forecast, chart, statistics, economic calendar and news.

tradingeconomics.com

In conclusion.
What is the best direction to create this?
What are your experiences if any?
How do you want me to proceed?

Thanks in advance

 

[sandy666]

I will take all data then.

you mean like in the last example?
or
detailed table for each country together?

 

[sandy666]

Do you have any recommendations of who can help me with the heat map?

one way is post with detailed description
and an example what you want
... and wait ...

or search MrExcel for heat map

 

[Corried]

you mean like in the last example?
or
detailed table for each country together?

I mean this one: heat2.xlsm

 

[sandy666]

I mean this one: heat2.xlsm

so you have
but all calculations and transform you need to do with Power Query Editor