Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
TKL
 
Posts: n/a
Default 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.
  #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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can time be used as both the x and y variables in scatter plots? [email protected] Charts and Charting in Excel 1 December 8th 05 12:58 PM
Can time be used as both the x and y variables in scatter plots? [email protected] Charts and Charting in Excel 1 December 8th 05 12:58 PM
two scatter plots with two trendlines on one chart Leo Bueno Charts and Charting in Excel 1 November 14th 05 12:47 AM
Excel gives me line plots - I want scatter plots Pangloss Charts and Charting in Excel 1 October 14th 05 02:15 PM
Ellipses in scatter plots rchris68 Charts and Charting in Excel 1 March 15th 05 04:01 PM


All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"