Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I plot z = f(x,y) in 2D cartezian coordinates ? | Charts and Charting in Excel | |||
Excel - Plot Coordinates in a graph | Charts and Charting in Excel | |||
How can I use a worksheet to plot polar coordinates? | Charts and Charting in Excel | |||
Radar Plot using geographical coordinates | Charts and Charting in Excel | |||
Radar Plot using geographical coordinates | Charts and Charting in Excel |