| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series with named range on several identical sheets
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 -- caroline |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Series Named Range Problem | Charts and Charting in Excel | |||
| series w/ named range not shown when reopen chart | Charts and Charting in Excel | |||
| mult. w/sheets need identical view when opening (range, mag, cell) | Setting up and Configuration of Excel | |||
| Sheets named from range, and copy data? | Excel Discussion (Misc queries) | |||
| Add a data series dynamically to a named range? | Charts and Charting in Excel | |||
Threaded Mode
