I recently downloaded a US Map Dashboard template from Excel Dashboard School. Everything worked fine with the file until I tried to change the state level metrics. They were defaulted to be dollar values, such as $50,000 in Sales for Pennsylvania. However, when I went to adjust these metrics to be a Year-over-Year %, such as -3.0% for Pennsylvania, all of the state colors on the map stay at the lowest level of the color templates. I cannot figure out how to adjust the color scales to pick-up on the fact that I went from currency numbers to percentages. Everything else about the file still works (with some adjustments made) and the VBA code is password protected so I'm assuming it is something minor I have to change like a conditional format over the map.
Bookmarks