Multiple Charts within 1 Chart Sheet

T

timg

How can I place 2,3, or 4 charts within 1 chart sheet? I'd prefer not to use the embedded chart approach. Thanks.
 
J

Jon Peltier

They will be embedded, but in the chart sheet, not in a work sheet.
Select a blank cell that is itself surrounded by blank cells, and press
the F11 key to make a blank chart sheet. Now make the charts you want to
place on the chart sheet, and in the last step of the wizard, Location,
select As Object In and choose the chart sheet from the drop down list.
To move an existing chart, right click on it, choose Location from the
pop up menu, and choose As Object In and select the chart sheet as above.

- Jon
 

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