Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Is there a way to display multiple charts from different worksheets on one
page for print out in Excel? Or, is there a way to somehow merge the chart information of two or more charts into one single graph without altering the unique characteristics of each one? I have 4 charts of the stacked column type with related information that I need to display on the same sheet. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi,
Yes you can use the charts Location option to place a chartobject on a chart sheet instead of a worksheet. To create a blank chart sheet press F11 making sure the active cell is empty and not adjacent to any populated cells. select the chart to be move and right click, from the context menu chose Location. From the As Object In dropdown chose the blank chart sheet. Repeat for other charts and then finally adjust layout of chartobjects within chartsheet. Cheers Andy magnoliak77 wrote: Is there a way to display multiple charts from different worksheets on one page for print out in Excel? Or, is there a way to somehow merge the chart information of two or more charts into one single graph without altering the unique characteristics of each one? I have 4 charts of the stacked column type with related information that I need to display on the same sheet. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to display current page number in any cell of that page. | Excel Discussion (Misc queries) | |||
Multiple Chart on Single Page | Charts and Charting in Excel | |||
Display Comments on Each Page | Excel Discussion (Misc queries) | |||
display main column on next page | Excel Discussion (Misc queries) | |||
two charts on one chart page | Charts and Charting in Excel |