View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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.