|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
05-29-2005, 07:05 AM
|
|||
|
|||
|
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
05-29-2005, 07:05 AM
|
|||
|
|||
|
Edit
I mean like a simple y=mx+b line
|
|
#3
05-29-2005, 01:05 PM
|
|||
|
|||
|
Re: Edit
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
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
