Can Excel plot polynomial equations?

[Guest]

I have a polynomial equation that I need to plot. The only program that I
have that might be able to do this is Excel and I am not sure how to go about
it. Any help would be greatly appreciated.

 

[Bernard Liengme]

Lets use 2x^3-3x^2+6x+10 as example
In A1:A20 (or a large/smaller range) enter x values (1,2,3, or 1.1, 1.2,
1.3)
In B1 enter =2*A1^3-3*a1^2+6*A1-10; Copy down to B20
Select a1:B20; start chart wizard; make an XY chart (regardless of what it
may sound like you do NOT want a Line chart)

Once you have had success doing this, may I suggest you read an Excel book

best wishes

 

[Tushar Mehta]

Complementing Bernard's suggestion, which will also teach you something
extra, a black-box approach would be: PLOT manager
http://www.tushar-mehta.com/excel/software/plot_manager/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions