Dynamic chart question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brad - 21 Jul 2006 16:10 GMT

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?

Reply to this Message

Greg Wilson - 21 Jul 2006 20:50 GMT

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

> I understand using the offset and named range
>
[quoted text clipped - 3 lines]
>
> What am I doing wrong?

Reply to this Message

Brad - 21 Jul 2006 20:55 GMT

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.

> 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
[quoted text clipped - 16 lines]
> >
> > What am I doing wrong?

Reply to this Message

Jon Peltier - 22 Jul 2006 02:29 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> Thanks - that is what I eventually ended up doing. Was hoping to do it
> through the data range then each item in the series.
[quoted text clipped - 26 lines]
>> >
>> > What am I doing wrong?

Reply to this Message