Hi all,
Newby to the VBA world and am trying to wrap my head around a problem...Hopefully someone can point me in the right direction.
Firstly, I have a dataset that spans from Jan 2003 to March 2013 (frequency = monthly) which will be constantly added to on a monthly basis (attached).
The goal is to create a heat map using economic indicators based on the colour key (7 colours) in the below table. However there is varying min and max points on each row of data so the attached colour scheme will have to have the same conditional formatting applied to each row individually.
Has anyone got any ideas on how I can accomplish this?
Thanks,
E
<tbody>
</tbody>
Newby to the VBA world and am trying to wrap my head around a problem...Hopefully someone can point me in the right direction.
Firstly, I have a dataset that spans from Jan 2003 to March 2013 (frequency = monthly) which will be constantly added to on a monthly basis (attached).
The goal is to create a heat map using economic indicators based on the colour key (7 colours) in the below table. However there is varying min and max points on each row of data so the attached colour scheme will have to have the same conditional formatting applied to each row individually.
Has anyone got any ideas on how I can accomplish this?
Thanks,
E
Indicators | Jan-03 | Feb-03 | Mar-03 | Apr-03 | May-03 | Jun-03 | Jul-03 | Aug-03 | Sep-03 | |
USA | ||||||||||
ISM | 51.3 | 48.8 | 46.3 | 46.1 | 49 | 49 | 51 | 53.2 | 52.4 | |
ISM Non Manufacturing | 53.3 | 52.6 | 49.1 | 50.1 | 52.8 | 54.3 | 57.3 | 59.1 | 57.6 | |
Phili Fed | 6 | -1.5 | -4.1 | -6.7 | -0.6 | 3.6 | 7.7 | 20.2 | 20.9 | |
Univ Chicago PMI | 54.4 | 53.6 | 48.7 | 47.8 | 49.8 | 54.9 | 55 | 59.4 | 54.1 | |
Univ of Michigan Consumer Conf | 82.4 | 79.9 | 77.6 | 86 | 92.1 | 89.7 | 90.9 | 89.3 | 87.7 | |
Consumer Confidence (Conf Board) | 192.4 | 192.5 | 192.5 | 192.5 | 192.9 | 193 | 193.4 | 193.6 | 193.7 | |
Empire State | 8.13 | -3.53 | 6.51 | -14.4 | 15.61 | 25.29 | 19.18 | 15.55 | 20.48 | |
10-30 spread | ||||||||||
CPI (MoM) | 0.4 | 0.5 | 0.2 | -0.4 | -0.2 | 0.1 | 0.3 | 0.4 | 0.3 | |
Ind production (MoM) | 0.78 | 0.37 | -0.17 | -0.83 | 0.01 | 0.04 | 0.3 | -0.09 | 0.58 | |
Durable Goods | 3 | 2.8 | -0.1 | -2.1 | 1.1 | 1.3 | 0.2 | -0.2 | 2.7 | |
Unemployment Rate | ||||||||||
S&P 500 INDEX | 909.03 | 908.59 | 929.01 | 922.93 | 909.93 | 927.58 | 927.57 | 926.26 | 931.66 | |
Eurozone | ||||||||||
PMI | 56.1 | 56.7 | 57 | 57.7 | 57.4 | 56.6 | 56.6 | 57 | 56.6 | |
PMI Non Manfacturing | ||||||||||
IFO | 89.9 | 91 | 95.1 | 104.4 | 116.8 | 109.6 | 117.8 | 109.6 | 104.4 | |
Belgium Leading Indicator | ||||||||||
ZEW | 29.9 | 28.7 | 29.6 | 29.5 | 35.5 | 38 | 50.5 | 58.1 | 69.6 | |
10-30 spread | ||||||||||
CPI | 94.67 | 95.09 | 95.69 | 95.77 | 95.69 | 95.77 | 95.69 | 95.85 | 96.19 | |
Industrial production | 1.5 | -0.6 | 0.5 | -1.5 | -0.2 | 1.6 | -1.1 | -0.3 | ||
Unemployment Rate | 8.97 | 9.03 | 9 | 9.07 | 9.2 | 9.2 | 9.3 | 9.37 | 9.3 | |
EUROSTOXX 50 SX5P | 2522.24 | 2502.19 | 2529.86 | 2504.91 | 2449.78 | 2492.18 | 2489.01 | 2497.61 | 2509.43 | |
<tbody> </tbody> | Dark Blue | |||||||||
<tbody> </tbody> | Light Blue | |||||||||
<tbody> </tbody> | Lighter Blue | |||||||||
<tbody> </tbody> | white | |||||||||
<tbody> </tbody> | yellow | |||||||||
<tbody> </tbody> | orange | |||||||||
<tbody> </tbody> | red | |||||||||
<tbody>
</tbody>