Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can you insert a graph inside another graph? if so how?
I am trying to insert a graph into another graph. Is this possible?
Jim |
#2
|
|||
|
|||
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 Jim Smith wrote: I am trying to insert a graph into another graph. Is this possible? Jim -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
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/ _______ Andy Pope wrote: 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 Jim Smith wrote: I am trying to insert a graph into another graph. Is this possible? Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need macro to insert text string while inside cell (formula) | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
insert picture | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) |