Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
I mean like a simple y=mx+b line
|
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colour part of a line on an X Y graph | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
How do you fit a line to a graph? | Excel Discussion (Misc queries) | |||
Line and Column Graph | Charts and Charting in Excel | |||
Can you have a vertical line graph in Excel 2003 | Charts and Charting in Excel |