ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I join graphs together in Excel? (https://www.excelbanter.com/charts-charting-excel/54924-how-do-i-join-graphs-together-excel.html)

Clare

How do I join graphs together in Excel?
 
I have two graphs drawn in excel, the x-axises are slightly different, is
there a way i can join these two graphs together

Jon Peltier

How do I join graphs together in Excel?
 
Depends on what chart type they are.

If they're both XY: select one chart, copy, select the other chart, Edit menu
Paste Special Formulas. This puts the data from the copied chart into the pasted
chart.

If they are column/line/area types, the X axes are connected with the first series
in the chart, so there may be more complicated steps you need to take.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Clare wrote:
I have two graphs drawn in excel, the x-axises are slightly different, is
there a way i can join these two graphs together




All times are GMT +1. The time now is 09:01 PM.

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