If you first save the sheet as a template (with working sheet-level names in
the chart data references), you can insert new sheets based on this
template, and the names will work on the inserted sheet.

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


"Andy Pope" wrote in message
...
Hi,

Assuming your sheet level named range is
Sheet1!ChartDates
the sheet level syntax should remain.

Your problem will occur when copying the sheet as the chart will replace
the sheet level named range with an array of static values.

Best stick with a workbook level reference that you revised to sheet level
after copying the sheet.

Cheers
Andy

caroline wrote:
I have named ranges on sheet1 to create my chart.
ChartDates for the X axis
Data1 for the values
I then entered SERIES('Sheet1'!$B$3,'Sheet1'!ChartDates,'Sheet1'! Data1,1)
But Excel rewrote it that way
SERIES('WorkbookName.xls'$B$3,'WorkbookName.xls'!C hartDates,'WorkbookName.xls'!Data1,1)

This is not what I am after, because I am copying the sheet several times
and I would like each graph to get the data from its own sheet (each
sheet has a range named ChartDates and Data1.

Can you help? Thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info