ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I merge 2 graphs into 1? (https://www.excelbanter.com/excel-discussion-misc-queries/103852-how-do-i-merge-2-graphs-into-1-a.html)

jpat54

How do I merge 2 graphs into 1?
 
I have 2 graphs. I need to put one on top of the other and still be able to
see the one on the bottom. Need to merge/layer them. Sent to Back/Send
Backward does not work

Manoj

How do I merge 2 graphs into 1?
 
Right click on the chart... Select "Location".... Select option "As an
object in"

and select the sheet name in which the other chart is present. this will
transfer the chart on to the other chart sheet. Please ensure that the
charts are in the chart sheet and not embedded in a normal worksheet.

See if this works.

Manoj

"jpat54" wrote:

I have 2 graphs. I need to put one on top of the other and still be able to
see the one on the bottom. Need to merge/layer them. Sent to Back/Send
Backward does not work


DCSwearingen

How do I merge 2 graphs into 1?
 

Jon has a lot of Excel charting tips on his site.
http://www.peltiertech.com/index.html

Maybe one can be adapted for your purpose...

jpat54 Wrote:
I have 2 graphs. I need to put one on top of the other and still be
able to
see the one on the bottom. Need to merge/layer them. Sent to
Back/Send
Backward does not work



--
DCSwearingen

Getting old, but love computers.
------------------------------------------------------------------------
DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506
View this thread: http://www.excelforum.com/showthread...hreadid=569582



All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com