Graph Simple/Quadratic equations
 

Is there a way to graph simple and quadratic equations in
Excel?

Alberto.

Graph Simple/Quadratic equations
 

Alberto -

Simple answer: Put the coefficients into the worksheet, say, E1, E2, and
E3 for the constant, first order, and second order coefficients (skip
the E3 part for a linear equation). In A2 to A10 (or whatever) put the X
values you want to cover. In B2 enter this equation:

=$E$1+$E$2*A2+$E$3*A2^2

and fill it down column B as far as you have values in column A. Now
just make an XY Scatter chart (not a Line chart) of these values.

If you want to get fancier, check out the formula charting examples on
Stephen Bullen's site (http://bmsltd.co.uk) and Tushar Mehta's site
(http://tushar-mehta.com).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Alberto Tejada wrote:

Is there a way to graph simple and quadratic equations in
Excel?

Alberto.

Graph Simple/Quadratic equations
 

put a formula representing the equation in a sheet and refering to the cell
to the left
File the formula down for as many points as you want to graph

put x values in the adjacent cell.

Graph the two columns using an X-Y scatter plot

Excel graphs numbers, so one way or another you have to feed the graph
numbers.

--
Regards,
Tom Ogilvy

"Alberto Tejada" wrote in message
...
Is there a way to graph simple and quadratic equations in
Excel?

Alberto.