I would suggest you start by downloading Stephen Bullen's FunChrt1.xls from

http://www.oaltd.co.uk/MVP/Default.htm

Shows how to define names for dynamic ranges that chart only what is available.

With that workbook, select B5 which is "Results"

Autofilter on that column for "Top 10" and see how the chart changes to show
only the visible data.

Your worksheet could be setup similarly so you Autofilter by the region to be
charted.


Gord Dibben MS Excel MVP

On Wed, 30 Jan 2008 08:39:01 -0800, LDP Analyst
wrote:

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.