Thread: Series with named range on several identical sheets
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default Series with named range on several identical sheets
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
Reply With QuoteReply With Quote