Thread: Correct Chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Correct Chart

In A1 enter the word Temperature; in B1 the word Altitude
In A2 down enter the temperature values
Enter -100 in A2, -90 in A3; select A2:A3 and drag the fill handle (small
solid square in bottom right corner of selected cells) down to A22 to get
values with an interval of 10.
In B2 down enter the corresponding altitude values
Click anywhere inside the arrange (or select A1 to the end of the B data)
Click the Chart wizard and specify XY chart (DO NOT use LINE) with a line
joining data point (smooth or jagged - as you wish)
The come back with the next bunch of questions
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"P. Zicari" wrote in message
...
I am trying to create a chart with a X-axis that shows temperature
from -100
to 100 and a Y-axis that shows altitude fro 0-100. The data will create a
"wavy" line. Any suggestions on the best chart to use and how to
configure
the spreadsheet to create this would be greatly appreciated.

Thanks in advance.