I'm hoping to get some help with automatically updating the chart range in Excel based on what's selected in a drop down list.
I have 3 selections for my drop down list:
Saskatchewan. I want each selection to reference a list of cities. Say (for example)
Alberta has cities A-G,
Saskatchewan has cities H-K, then
All has cities A-K.
I want to plot the cities vs several metrics on ONE chart but I do not know how to update the chart range to show cities A-G if
Alberta is selected in the drop down or A-K if
All is selected, etc.
How can I do this?