How do you create a graph of an equation in excel?

f3hnx0.jpg
 
div0 said:
Excel does work in Radians for the Trigonometric functions (SIN, COS, etc)

You can convert with the built in function as above or if you're using degrees, then you can convert to radians by multiplying by PI/180.

So y=2* SIN(x*PI()/180)

You should get a graph which starts at 0, curves up to 2 at 90 degrees, then down to 0 again at 180 degrees, then down to -2 at 270 degrees and back to 0 at 360 degress.
Click to expand...

That makes no sense to me mate :(
 
You've plotted y = 2*SIN(x)

But x is in degrees!

You either need to change your formula for y to y=2*SIN(X*PI()/180)

Or convert all numbers in column A from 0->360 degrees, into radians, by multiplying them by PI/180.
 
-Mike- said:
So I take it my funky graph (line graph) should be ok?
Click to expand...
if you use the equation that div0 or I gave you that converts degrees to radians for excel to understand then yes. You should have a graph that goes from 2 to -2 on the V1 axis and smoothly goes from 0 at theta=0, to 2 at theta=90, back to 0 again at theta=180, -2 at theta=270 and then finally back to 0 at theta=360.

Sorry if I confused you, I shouldn't try to do too many things at once and then also try to help :)

Edit: For that graph you posted you need to use the second correct equation I gave you the one with radians(A2) instead of the first one which was wrong :)
 
Do this:

In Column A make Cell A1 say DEGREES. Then make cell A2 say 0, cell A3 say 1, fill down column A till you have 0 to 360.

Then in Column B make Cell B1 say RADIANS. In Cell B2 put the formula =A2*PI()/180 and fill down

Then in Column C make Cell C1 say Y-axis. In cell C2 put the formula =2*SIN(B2) and fill down.

Then highlight columns B and C and plot your graph.
 
div0 said:
Do this:

In Column A make Cell A1 say DEGREES. Then make cell A2 say 0, cell A3 say 1, fill down column A till you have 0 to 360.

Then in Column B make Cell B1 say RADIANS. In Cell B2 put the formula =A2*PI()/180 and fill down

Then in Column C make Cell C1 say Y-axis. In cell C2 put the formula =2*SIN(B2) and fill down.

Then highlight columns B and C and plot your graph.
Click to expand...

Thank you kindly :)
 
You must log in or register to reply here.
Back
Top Bottom