ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   plot two groups of numbers on one series of xy coordinates. (https://www.excelbanter.com/charts-charting-excel/261557-plot-two-groups-numbers-one-series-xy-coordinates.html)

elwood

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

Bernard Liengme[_2_]

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




All times are GMT +1. The time now is 01:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com