Good morning, I am trying to create a heat map of the US that changes the shade of each state based on the values in another table range (B1:F45). There are 6 "tiers" of shade for each range of values:
<colgroup><col><col></colgroup><tbody>
</tbody>
I have created three tables. The first connects the state abbreviation to the shape of the object/state. The second connects the abbreviation of the state to the values that will change. The third changes the connects the value to the color scheme that I want to be reflected based on each value.
This third table is where I am having the difficulty. I created my spreadsheet based on the tutorial in this link but the link in the "MapValuetoColor" table that contains the connecting RGB code to the objects is broken and I do not know what to do next.
I am a VBA novice which is causing me a difficult time figuring out how to get these objects to changed based on the values in the table. Can anyone help me to determine how to get the states to change based on this criteria? Thank you in advance.
| 0 | RGB(255,255,255) | |||
| 1-140 | RGB(235,241,222) | |||
| 141-280 | RGB(216,228,188) | |||
| 281-420 | RGB(196,215,155) | |||
| 421-560 | RGB(118,147,60) | |||
| 561-700 | RGB(79,98,40) |
<colgroup><col><col></colgroup><tbody>
</tbody>
I have created three tables. The first connects the state abbreviation to the shape of the object/state. The second connects the abbreviation of the state to the values that will change. The third changes the connects the value to the color scheme that I want to be reflected based on each value.
This third table is where I am having the difficulty. I created my spreadsheet based on the tutorial in this link but the link in the "MapValuetoColor" table that contains the connecting RGB code to the objects is broken and I do not know what to do next.
I am a VBA novice which is causing me a difficult time figuring out how to get these objects to changed based on the values in the table. Can anyone help me to determine how to get the states to change based on this criteria? Thank you in advance.
