0
$\begingroup$

I am doing an uni assignment and have worked out a linear equation which plots temperature over time. I have this in a graph now but that required me to use a lot of calculations in the spreadsheet.

How can I use the basic equation and display a graph like normal graphing software would?

my equation is $y=\frac{25000*x}{1020*3770}$

I am not sure on the easiest way to put this in to an excel chart to use in a presentation

  • 0
    Does th$i$s help? http://www.youtube.com/watch?v=fIwanUubn7Q2012-09-28

1 Answers 1

1

You can use column A as $x$ and B as $y$. In the cells of column A, you can enter the $x$ values you like. In the B column, supposing the $x$ value is in row 1, then in B1, you can enter

=25000*A1/(1012*3770) 

which calculates the corresponding $y$ value for a given $x$ value. You can then copy and paste this down column B for as many rows as you need.

  • 0
    If you highlight the cells in the column you want to paste in, control-d gives copy down. The cell references are automatically updated, which is what you want here.2012-09-28