Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can time be used as both the x and y variables in scatter plots? | Charts and Charting in Excel | |||
Can time be used as both the x and y variables in scatter plots? | Charts and Charting in Excel | |||
two scatter plots with two trendlines on one chart | Charts and Charting in Excel | |||
Excel gives me line plots - I want scatter plots | Charts and Charting in Excel | |||
Ellipses in scatter plots | Charts and Charting in Excel |