Seperate data series on a similar X-axis
 

I am using Excel 2000.

I need to be able to plot two seperate curves: Engine Power and Drag. The
two curves both have speed on the x-axis and power on the y-axis.

The problem is that the two sets of data are presented with different values
for speed.


Speed drag

(kph) (watts)

10 37.75

20 269.3

30 888.45

40 2089

50 4064.75

60 7009.5

70 11117.5

80 16581.2



Speed engine power

(kph) (watts)

7.49 -36.65

14.98 104.72

22.47 587.48

29.96 934.1

37.45 1502.73

44.94 1897.52

52.43 2162.46

59.92 2236.81

67.41 2007.48

74.9 1759.29


How can I present both sets of data on a single graph, with the correct
X-axis labelling, so as to ascertain the intersection point?

Thanks in advance for your help.


--
Enzo

I wear the cheese. It does not wear me.

Seperate data series on a similar X-axis
 

Make an XY chart, not a line chart. Create the chart using the first set of
data, then copy the next set, select the chart, go to Edit menu Paste
Special, and add the new data as a new series, X values in first column,
etc.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Enzo Matrix" wrote in message
...
I am using Excel 2000.

I need to be able to plot two seperate curves: Engine Power and Drag. The
two curves both have speed on the x-axis and power on the y-axis.

The problem is that the two sets of data are presented with different
values for speed.


Speed drag

(kph) (watts)

10 37.75

20 269.3

30 888.45

40 2089

50 4064.75

60 7009.5

70 11117.5

80 16581.2



Speed engine power

(kph) (watts)

7.49 -36.65

14.98 104.72

22.47 587.48

29.96 934.1

37.45 1502.73

44.94 1897.52

52.43 2162.46

59.92 2236.81

67.41 2007.48

74.9 1759.29


How can I present both sets of data on a single graph, with the correct
X-axis labelling, so as to ascertain the intersection point?

Thanks in advance for your help.


--
Enzo

I wear the cheese. It does not wear me.

Seperate data series on a similar X-axis
 

Jon Peltier wrote:
Make an XY chart, not a line chart. Create the chart using the first
set of data, then copy the next set, select the chart, go to Edit
menu Paste Special, and add the new data as a new series, X values
in first column, etc.

- Jon

Excellent! Thank you very much indeed, Jon. That's *exactly* what I need!

--
Enzo

I wear the cheese. It does not wear me.