Straight Line Graph
 

How do I create a straight line graph with simple x and y axes eg. for a
conversion from celcuis to farenheit etc.

I mean like a simple y=mx+b line

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/
_______

subatomicguy wrote:

I mean like a simple y=mx+b line