How do I display multiple charts on one page?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

magnoliak77 - 30 Jun 2006 06:25 GMT

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.

Reply to this Message

Andy Pope - 30 Jun 2006 10:10 GMT

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

> 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.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message