Take the 2-minute tour ×
Mathematics Stack Exchange is a question and answer site for people studying math at any level and professionals in related fields. It's 100% free, no registration required.

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

share|improve this question
    
I would recommend learning something that produces graphics that make this sort of thing easy and you can generate many graphic types (excel should be able to do this too). For example, Mathematica, Maple, Maxima, Sage ... See: at wolframalpha.com, type plot (25000∗x)/(1020∗3770) –  Amzoti Sep 28 '12 at 2:56
    
I used wolframaplha but all my data is in excel thought there might be an easier way to do it. I can use another program for my mac and drag the graphic over to powerpoint I suppose –  Ashley Hughes Sep 28 '12 at 3:11
    
Does this help? youtube.com/watch?v=fIwanUubn7Q –  Amzoti Sep 28 '12 at 3:21

1 Answer 1

up vote 1 down vote accepted

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.

share|improve this answer
    
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. –  Ross Millikan Sep 28 '12 at 4:09

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.