Can you insert a graph inside another graph? if so how?

  • Thread starter Thread starter Guest
  • Start date Start date
Hi,

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.

Cheers
Andy
 
I don't believe you can embed chartobjects within chartobjects though.

No, but you could make one smaller than the other, and put it in front
of the larger one (z-order).

Or you could copy the small one as a picture, and paste it into the
larger chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top