Dynamic chart question

[Brad]

I understand using the offset and named range

However, when I go into the data range (of the chart) and try to put in the
range that I created - it doesn't stick. Meaning I can type in the range
name - hit okay and when go back to date range the name is not there

What am I doing wrong?

 

[Greg Wilson]

I do it through the Series tab instead of Data Range tab of the Source Data
dialog. I enter the range name in the Values window (X Values and Y Values if
XYScatter). You need to preface the name with the workbook name. If you enter
the worksheet name instead of the wb name it will typically change it but
won't raise an error. For example:

='Sales Report.xls'!DataRng

where DataRng is the range name.

Regards,
Greg

 

[Brad]

Thanks - that is what I eventually ended up doing. Was hoping to do it
through the data range then each item in the series.

Thank again.

 

[Jon Peltier]

You can set the source data using a defined name in the Data Range tab, but
it is converted to the cell address, as you've discovered.

- Jon