I have set up a chart that automatically updates as new data is entered into
the spreadsheet. The problem is....I would like to copy this worksheet so
that there are 9 different worksheets (of this same set-up only with
different names) in the same workbook. What is the correct way for me to
make copies of worksheet, so that my chart in each worksheet still
automatically updates based off of what is entered in that worksheet?

The directions I used for setting up my original worksheet is located at
http://peltiertech.com/Excel/Charts/DynamicCharts.html Maybe this only
works for one worksheet per workbook??

I have tried making a copy of the original and changing the name but then
this also changes the original.

Help is appreciated....thanks.

When you define the Names, they have to be defined locally, not globally.
This means you need to precede the name of the Name with the sheet name when
defining it: 'My Sheet'!MyName instead of simply MyName. In this way, each
sheet will have a set of Names with the same names (confusing choice of
feature moniker).

When you use these names in the series formula or in the Source Data
Series dialog, the sheet name preceding the Name in the formula or entry box
will not be converted to the workbook name. I guess I need to update that
web page....

Use the free Name Manager on Jan Karel Pieterse's web site
(http://jkp-ads.com) for more control and understanding of the process.

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


"Amber" wrote in message
...
I have set up a chart that automatically updates as new data is entered
into
the spreadsheet. The problem is....I would like to copy this worksheet so
that there are 9 different worksheets (of this same set-up only with
different names) in the same workbook. What is the correct way for me to
make copies of worksheet, so that my chart in each worksheet still
automatically updates based off of what is entered in that worksheet?

The directions I used for setting up my original worksheet is located at
http://peltiertech.com/Excel/Charts/DynamicCharts.html Maybe this only
works for one worksheet per workbook??

I have tried making a copy of the original and changing the name but then
this also changes the original.

Help is appreciated....thanks.