Defined name range disappears from Data Range field

[John Holland]

Help!

I am charting data using defined name ranges for the Source Data - > Data
Range.

It works great... it plots the data fine.

But when I go back into the Data Range field, the define name has been
changed to the literal cell references. This is not helpful if I want to
redefine the named range to represent a different set of cells.

Any suggestion? Thanks.

 

[Jon Peltier]

John -

To use a dynamic range for your chart, you need to define names for the X and Y
values of each series in the chart. This means you can use dynamic ranges to vary
the number of points in a series, but not the number of series in a chart. See this
page and the articles it links to:

http://peltiertech.com/Excel/Charts/Dynamics.html

You could instead use a Worksheet_Change or _Calculate event to update the chart's
source data range in one shot, instead of using many formulas.

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