Jon

Thank you for the greate tip.

Shinya

"Jon Peltier" wrote in message
...
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