Put a series of X values (or if it's a straight line, just the first and
last X values) into one column. Using a formula in the second column,
compute Y values for each X value. If you enter the formula in the top
cell, you can drag to fill the cells below
F C (formula, assuming "F" is in cell A1)
0 -17.8 =(A2-32)*5/9
32 0.0 =(A3-32)*5/9
100 37.8 =(A4-32)*5/9
212 100.0 =(A5-32)*5/9
Select the data, start the Chart Wizard, and create an XY Scatter chart.
Format as needed.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
