Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jim Smith
 
Posts: n/a
Default 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   Report Post  
Andy Pope
 
Posts: n/a
Default

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   Report Post  
Jon Peltier
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need macro to insert text string while inside cell (formula) BrianB Excel Discussion (Misc queries) 0 May 31st 05 03:18 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
insert picture BillGwyer Excel Discussion (Misc queries) 1 March 4th 05 07:37 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 07:57 PM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 09:03 PM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"