View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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