LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combination chart: primary data labels obscure line series on secondary axis Uhl Charts and Charting in Excel 3 December 12th 06 08:52 PM
map data (x-y axis) with diffent series name Penny Charts and Charting in Excel 1 October 16th 06 11:28 AM
Selecting part of a series for a chart? Al Charts and Charting in Excel 6 May 16th 06 12:45 PM
Chart -- Source Data... -- Series dialog window Sarah Jane Charts and Charting in Excel 2 January 24th 06 10:27 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM


All times are GMT +1. The time now is 04:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"