If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How To Modify One Point In A Graph... | Pierre | Charts and Charting | 3 | November 25th, 2004 10:08 AM |
How can I insert a footnote into my excell workbook graph? | WOwens | Charts and Charting | 2 | September 23rd, 2004 05:00 AM |
INSERT query inside an error handler? | Richard Hollenbeck | Running & Setting Up Queries | 7 | September 11th, 2004 02:31 PM |
Insert graph in cell | Evon | Charts and Charting | 6 | November 10th, 2003 11:35 PM |