Hello,
I am new to this site, and a fumbling learner of Excel, so I am grateful for
any help.

I am trying to make a chart by selecting a region from the drop down. I hope
that it will populate a chart with the data from the region, as well as be
self adjusting in the axes of the chart based on the size of the region, but
I'm not educated enough to get to that point.

Any words of advice will be welcome.