Seperate data series on a similar X-axis

[Enzo Matrix]

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.

 

[Jon Peltier]

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

 

[Enzo Matrix]

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!