Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 563
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


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
How do I plot z = f(x,y) in 2D cartezian coordinates ? Tim Charts and Charting in Excel 6 August 20th 07 07:04 PM
Excel - Plot Coordinates in a graph McQuaid Charts and Charting in Excel 4 October 25th 06 01:10 PM
How can I use a worksheet to plot polar coordinates? louradam Charts and Charting in Excel 1 June 19th 06 04:43 PM
Radar Plot using geographical coordinates David Charts and Charting in Excel 1 June 2nd 05 01:20 PM
Radar Plot using geographical coordinates David Charts and Charting in Excel 2 May 31st 05 08:06 PM


All times are GMT +1. The time now is 03:17 AM.

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

About Us

"It's about Microsoft Excel"