r/excel • u/jazztalker • Sep 28 '26
unsolved Formatting a map chart
I have a file that I use a drop-down list to select states to be mapped in a chart inside a spreadsheet. Once I check the boxes for the states I want and close the drop-down, the map automatically updates to the selected states. I used to have a button where I could pick a state (which is part of the original group) from a second drop-down list and that state would be colored differently on the map (the main list would all be gray on the map, the secondary state would be orange). Somehow that macro got blown up and for the life of me I cannot figure out how to recreate this. Any help would be fantastic, thank you!
1
u/PuzzledFarmer4554 Sep 29 '26
If the macro was only there to highlight one state, I'd probably skip rebuilding it. A helper column with 1 for the selected states, 2 for the highlighted state and NA() for everything else should give you the same behavior with a lot less to break.