Excel graph with 2 y axis values?

[legos]

I don't know if this can be done or not. I have 3 fields of data, 2 are numbers and one is an event that occurs in relation to one of the numbers.
These are my fields
Temperature Depth Fossil
But they do not always occur at the same depth, exp
T1 D1 F1
T2 D2
D3 F2
T3 D4
T4 D5
D6 F3
T5 D6 F4 ect
can i make a graph where the temperature is on the x axis, the depth is on the y axis, with values in reverse order and x and y intersecting at 0 and have straight lines with text saying what fossil occurs at that depth. i'll try to draw it below

Temperature
0_____100_______200_____300____400__________
|D | E 1000|__\_________________________Fossil 1
P | T | H 2000| |______\_____________________Fossil 2
| 3000| |_________\__________________Fossil 3
| 4000|
Durible Outer Casing to Prevent Fall-Apart

 

[GlennUK]

You need to have the fossil data in separate series, like this
T vs D F2 F3 F4
0 0 2000 3350 4400
50 750 2000 3350 4400
100 1500 2000 3350 4400
150 2250 2000 3350 4400
200 3000 2000 3350 4400
250 3750 2000 3350 4400
300 4250 2000 3350 4400
350 5000 2000 3350 4400

Select the first 2 columns and start the chart wizard, and make an X-Y scatter chart ( sub-type "Scatter with data points connected by lines without markers ). Right click the Y axis, which will show a shortcut menu, and select Format Axis, and on the Scale tab tick Values In Reverse Order and press OK.

Now select the cells containing the text "F2" and its data and point at the border of the select and click and drag onto the chart and release, which should add it as a new series. Repeat for F3 and again for F4, and you should have something close to what you want.

Cheers, Glenn.