Home |
Search |
Today's Posts |
#1
|
|||
|
|||
3-D references in charts
Can I get sourse data for a line graph from multiple worksheets in a workbook?
|
#2
|
|||
|
|||
You can't do it this way. But if the layout is the same on each sheet you can
sum the data e.g. =SUM(Sheet2:Sheet3!C2) and graph that Regards Peter "Chez" wrote: Can I get sourse data for a line graph from multiple worksheets in a workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
initial size of new charts | Charts and Charting in Excel | |||
To get a lot of charts that contain different values in a minute | Charts and Charting in Excel | |||
pie charts - how to include "zero" fields on Legends | Charts and Charting in Excel | |||
Macro for multiple charts | Excel Worksheet Functions |