Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up one chart for multiple worksheets?
I have four worksheets with totals, I would like to create one chart for the
total of each individual worksheet. Can I do this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up one chart for multiple worksheets?
You want one chart with data for all sheets, or one chart that you then copy
to use on all sheets? To get data from one sheet into a chart on another sheet, one way is to copy the data, select the chart, and use Edit menu Paste Special to add the data as a new series. To use a chart on a sheet with an identical data layout, copy the sheet with the chart and the data, then copy the data from another sheet, and paste it over top of the data on the copied sheet. The chart should update after the data is changed. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Mimi" wrote in message ... I have four worksheets with totals, I would like to create one chart for the total of each individual worksheet. Can I do this? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up one chart for multiple worksheets?
Thank you Jon!
"Jon Peltier" wrote: You want one chart with data for all sheets, or one chart that you then copy to use on all sheets? To get data from one sheet into a chart on another sheet, one way is to copy the data, select the chart, and use Edit menu Paste Special to add the data as a new series. To use a chart on a sheet with an identical data layout, copy the sheet with the chart and the data, then copy the data from another sheet, and paste it over top of the data on the copied sheet. The chart should update after the data is changed. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Mimi" wrote in message ... I have four worksheets with totals, I would like to create one chart for the total of each individual worksheet. Can I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I limit my chart | Charts and Charting in Excel | |||
Making a chart using data from different worksheets in a workbook. | Charts and Charting in Excel | |||
Chart Property Confusion | Charts and Charting in Excel | |||
Line chart from multiple worksheets | Charts and Charting in Excel | |||
tick mark labels | Charts and Charting in Excel |