View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Enzo Matrix Enzo Matrix is offline
external usenet poster
 
Posts: 6
Default 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.