You can enter the name, preceded by the worksheet name and exclamation
point, for the data range, but Excel will convert this name to its cell
address. If you want the chart to be dynamic as the name changes its size,
you have to define a name for each series' data. This will not dynamically
change the number of series in the chart, but it will change the number of
points in a series.

Dynamic Charts:
http://peltiertech.com/WordPress/200...ynamic-charts/
http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MichaelR" wrote in message
...
Hi,

I'm trying to build a chart that that has a named range as its data
source.
The named range refers to a table that is 2x3 and is called geographydata.
Is
there any way that I can have the source data for the graph to be
geographydata?

Thanks!
Michael