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

[-Mike-]

Can anyone give me any idea of how to create a graph from 0-360 degrees in excel with a given equation?

Cheers

 

[Thunderbolt]

Can't plot the line as such, but plot various values in the equation, then add a line to the plotted points.

 

[rpstewart]

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.

 

[-Mike-]

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.

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

 

[Thunderbolt]

In trouble?
What level is the work you're doing, you could be using software like Maple or Matlab.

 

[-Mike-]

I've no idea what level this maths is but its for a foundation degree.

 

[Thunderbolt]

Well as far as I know, what rpstewart described is the only method.
Maybe you have to simplify the equation before you put it in.
Can't help unless you at least give us an idea what the equation looks like.

 

[Lee]

I used to have some software that drew equation graphs, but that was like 16 years ago now (probably still got it on FDD somewhere !). There must be something around that will do this, even if it's an Excel plug-in.

How about this:

http://www.mathgv.com/

 

[dangerstat]

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

Post the equation here

 

[feriso]

MathCAD? That's do it as iirc my Dad uses it for exactly the same thing

 

[Yakyb]

this is what mathmatica / matlab is for

 

[-Mike-]

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)

 

[Col_M]

Like said, autofill Column A with 0-360 if "0" is in cell A2 (assuming you title your columns)

in cell B2 enter =2*sin(A2) (WRONG see my next post)
then autofill again!

BTW that funny 0 with a line through is called Theta and it's pretty common, you'd be well to learn the name of it's friend Phi too who looks similar but the line through it is vertical.

 

[-Mike-]

Thanks for the help but as a graph it just draws a mess of points. I'm not sure thats what he was after

 

[Col_M]

Thanks for the help but as a graph it just draws a mess of points. I'm not sure thats what he was after

You should get a sine curve alternating between V1=2 and V1=-2

I just graphed it in excel and the automatically generated graph has 2 series, one plotted a linear line and the other was the sine curve that you're after, just delete the linear one and you'll be left with the sine wave.

edit: ok I used a line chart last time, I tried it with a smoothed scatter chart and that worked first time.
edit 2: ok I think I need to convert from radians to degrees as the chart is all over the place, I think excel works in radians my mistake

so your formula should be =2*SIN(RADIANS(A2))

oops

 

[-Mike-]

Sorry which type did you use?

 

[-Mike-]

Also my graph that I did get had a range of plus to minus two

 

[Col_M]

Also my graph that I did get had a range of plus to minus two

yeah edited, I made a mistake Excel works in radians not degrees

 

[-Mike-]

So I take it my funky graph (line graph) should be ok?

 

[div0]

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.