Thanks Andy. I reached that conclusion myself but thought that perhaps there
would be a way round it.
Buy the way, the sheet level syntax does not remain even with only one
sheet. I am using Excel 2003. Strange!
Thanks a lot
--
caroline


"Andy Pope" wrote:

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