How do I display multiple charts on one page?


G

Guest

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

Advertisements

A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top