Chart: Use range name for source data

Is it possible to specify range name for source data when creating
chart?

Shinya

Shinya -

You need to preface the range name with the worksheet name.

=Sheet1!MyRange

If you use this on the Data Range tab, Excel converts it to the regular
address, so it's not truly dynamic. If you use it on the Series tab for
every series, the range names are remembered, and the chart adjusts as
the ranges change in size.

More info:

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

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


sk wrote:

> Is it possible to specify range name for source data when creating
> chart?
>
> Shinya
>
>

Jon

Thank you for the greate tip.

Shinya

"Jon Peltier" <[email protected]> wrote in message
news:[email protected]...
> Shinya -
>
> You need to preface the range name with the worksheet name.
>
> =Sheet1!MyRange
>
> If you use this on the Data Range tab, Excel converts it to the regular
> address, so it's not truly dynamic. If you use it on the Series tab for
> every series, the range names are remembered, and the chart adjusts as
> the ranges change in size.
>
> More info:
>
> http://peltiertech.com/Excel/Charts/Dynamics.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> sk wrote:
>
> > Is it possible to specify range name for source data when creating
> > chart?
> >
> > Shinya
> >
> >