| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Name your ranges (Sales2002, Sales2003, etc), then add them to the chart
preceeded by the file name... eg Series 1 Values = Sales.xls!2002Sales Series 2 Values = Sales.xls!2003Sales etc... will do the trick... Hth, Oli -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scatter Graph - Data Label Problems | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| How can I plot a data series from multiple worksheets | Charts and Charting in Excel | |||
| How can I plot a data series from multiple worksheets | Charts and Charting in Excel | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Hybrid Mode
