Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
magnoliak77
 
Posts: n/a
Default How do I display multiple charts on one page?

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   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default How do I display multiple charts on one page?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to display current page number in any cell of that page. Laljeet Excel Discussion (Misc queries) 8 February 2nd 08 01:31 AM
Multiple Chart on Single Page BT Charts and Charting in Excel 4 March 10th 06 09:24 PM
Display Comments on Each Page Stanley Excel Discussion (Misc queries) 0 February 23rd 06 06:05 PM
display main column on next page jujumyamom Excel Discussion (Misc queries) 1 September 22nd 05 06:10 PM
two charts on one chart page kd Charts and Charting in Excel 2 September 13th 05 09:40 PM


All times are GMT +1. The time now is 04:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"