| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Multiple worksheet chart
How do I create one chart that shows data from several worksheets?
Gary Balaban |
|
#2
|
|||
|
|||
|
GB,
-- Two options that you can consider: (1) Create the chart by first using data from the single sheet in which you want the chart to reside. You can do this via the Chart Wizard. Then, add the new series that refer to the other sheets as secondary steps. (2) Create a summary range on the single sheet in which you want the chart to reside. The summary range will consist of formulas referring to the data on the other sheets. After the summary range is complated, create the chart from the summary range. You can use the Chart Wizard for this too. ---- Regards, John Mansfield http://www.pdbook.com "GB" wrote: How do I create one chart that shows data from several worksheets? Gary Balaban |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
| Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
| How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
| Single worksheet, multiple pages? | Excel Discussion (Misc queries) | |||
| How To Refresh Chart Data Without Calculating The Worksheet | Charts and Charting in Excel | |||
Hybrid Mode
