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

A

Andy Pope

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
 
J

Jon Peltier

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/
_______
 

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

Similar Threads

Need help making graph 3
Plotting Graph with dynamic table 3
Getting the graph style I want 4
Automatic Macro to create 200 graphs 1
Plotting Line Graphs to Specific Bar Graphs 0
Overlay line graph points on bar graph 1
Graph Line Width ? 1
exporting data from a graph 0

Top