Combining Scatter Plots

[TKL]

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]

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