A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

plot two groups of numbers on one series of xy coordinates.



 
 
Thread Tools Display Modes
  #1  
Old April 15th, 2010, 04:48 AM posted to microsoft.public.excel.charting
Elwood
external usenet poster
 
Posts: 2
Default plot two groups of numbers on one series of xy coordinates.

how to create a plot from separate x and y values. i.e. y values do not
correspond to the same set of x values. example x1= 5, y1=10; x2= 8, y2=15
  #2  
Old April 15th, 2010, 01:35 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 516
Default plot two groups of numbers on one series of xy coordinates.

I can read your question 2 ways;
A) you data looks like this
x y
5 10
8 15
etc.
Select the data and make an XY chart

B) you have two sets of data
x1 y1
5 10
10 12
17 15
21 20
and
x2 y2
3 8
7 14
12 19
18 24
Make an XY chart of the first data series
Select all the data (including headers) for second set, and use Copy
Click the chart to activate it
Use Edit | Paste Special .... indicate New Series with x-values in first
column; press OK
The chart now has both data series
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme



"elwood" wrote in message
...
how to create a plot from separate x and y values. i.e. y values do not
correspond to the same set of x values. example x1= 5, y1=10; x2= 8, y2=15


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.