Simple chart help requested from newbie!

Hello everyone,

my first post here, and I'm in with a bone question straightaway, but I hope you can help.

I have 2 columns, one for altitude, going from 0 - 25000' in 5000' increments, and another for the absolute temperature, in K, falling from 288.15 to 238.65 linearly, iaw an equation for temp vs altitude which I am happy to say I managed without difficulty.

What I want to achieve, is a chart with Altitude on the 'y' axis and Temperature on the 'x' axis, and a plot of the temperature falling with increasing altitude - ie a negative gradient line.

What I actually get when I go through the chart wizard is as follows:

\1

where as you can see, the x axis appears to be some random control numbers from 0 - 6 and the y axis is altitude. However, the temp is also plotted wrt to the same y axis scale as the altitude, which means (due to the small temp numbers in volved) that the temp line is more or less flat across the bottom of the chart.

I have tried all sorts of messing around to get this to work, and I know now that I am missing something - probably to do with the original layout of the data and the way it is then selected to create a chart from.

Please help - I need this skill for a new job and even the Excel tutor on my level 2 course today couldn't help me!

Thanks in advance,

Russ

Actually, after ages of trying, I just tried selecting an xy scatter graph and switching the columns round and with a bit of fettling, bobs me uncle.

My problem was originally going for a line graph...

Ok .