You can embed multiple chartobjects into a chart sheet.
Press F11, making sure the cells surrounding the active cell are empty,
this should then create a blank chart sheet. If you then have some
charts on a worksheet these can be embeded in the empty chart sheet. To
do this right click a chart on the worksheet and click Location... From
the As Object In dropdown list select the chart sheet.
I don't believe you can embed chartobjects within chartobjects though.
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.