ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Combining Scatter Plots (https://www.excelbanter.com/charts-charting-excel/63326-combining-scatter-plots.html)

TKL

Combining Scatter Plots
 
Is there a simple way to combine two sets of X-Y data on one plot. Note here
that the X values in the two sets are not the same.

Andy Pope

Combining Scatter Plots
 
Hi,

Assuming you already have a xy scatter chart you can either use the
Source Data dialog to add a new series and then select the cells for the
x and y values. Or you can select the 2 columns of data and drag and
drop them onto the chartobject. The paste special dialog should be
displayed. Make sure the New Series option is ticked and also check
Categories X values in first column.

Cheers
Andy

TKL wrote:
Is there a simple way to combine two sets of X-Y data on one plot. Note here
that the X values in the two sets are not the same.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 08:19 AM.

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