Plotting temperature over time excel

Question

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

Answer 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.