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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks