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

-Mike-

-Mike-

-Mike-

Soldato
Joined
22 Dec 2002
Posts
10,165
Location
Minehead
Can anyone give me any idea of how to create a graph from 0-360 degrees in excel with a given equation?

Cheers
 
rpstewart said:
Auto fill 0-360 in column A, enter the equation as a formula in B1 referencing A1 for the degrees value then auto fill down. Graph as normal.

Simples.
Click to expand...

Thanks for the reply but given my formula and the question for my assignment it makes no sense. If I gave you the equation then I think I'd be in trouble so I can't explain it better :(
 
Use excel or autograph or graph paper to plot the following over a range of 0 (only its not a 0 its got a weird line through it)

From 0 - 360 degrees

V1 (the one is lower than that) = 2sin 0 (the weird 0 with the line)
 
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 :(
 
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