## How can I graph quadratic or quartic equations

MS EXCEL

### Next

• 1. how to add overlay line chart to stacked bar
I'm using Microsoft Excel for Mac OS X. I'm trying to create an overlay chart with a stacked bar with a line over it. I can only get it to do a regular bar chart with a line over it. What am I doing wrong? Thanks!

### How can I graph quadratic or quartic equations

```I want to know how can I graph equations from linear equations to quartic or
higher degree equations using excel charts utility?
```

### Re: How can I graph quadratic or quartic equations

```Decide your expression(s) for Y as a function of X.
Put a range of X values in the first column, & calculate the corresponding Y
values in the next column (and in the third & subsequent columns if you've
got more than one equation that you want to plot together).
Select the two (or more) columns.
Insert/ Chart/ XY  Scatter.
--
David Biddulph

```

### Re: How can I graph quadratic or quartic equations

```Thanks Mr. D. Biddulph.  Thanks very much.  When I posted my question I had
already done what you instructed, but the resulting curve was not acurated.
At least not even remotely alike the one resulting in a graphic calculator as
the TI-83. Even though the resulting values of f(x) were correct.  That was
the reason why I did asked my question. Do you know another method to do it
more acurately.

```

### Re: How can I graph quadratic or quartic equations

```Did you use appropriate significant digits in your coefficients? Probably,
if the calculated Y values are accurate, as you state.

Did you make an XY chart? A Line chart will not portray X values accurately,
and this is the most common reason for people to get inaccurate charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://www.**--****.com/
_______

```

### Re: How can I graph quadratic or quartic equations

```Thanks Mr. Peltier.  Yes I made an XY chart using curve lines... and the
digits in my coefficients were correct.  I think I did everything ok.  I mean
I  calculated the values of f(x) for each value of x in a range -10 to +10.
The resulting values were exact... Then I did <Insert, Object,Chart,
Scatter...> and the resulting graph wasn't even remotely alike the one that
you get in the graphic calculator. Thanks anyway...

```

### Re: How can I graph quadratic or quartic equations

```raidven  -

I don't understand.

If you already have an XY (Scatter) chart with correct results, why are you
choosing Insert | Object | Microsoft Graph Chart | ... ?

-  Mike
http://www.**--****.com/

```

### Re: How can I graph quadratic or quartic equations

trange, I don't see the reply.

There might be a difference in the algorithms used to generate the smoothed
curve. I avoid smoothed lines in charts whenever possible, because they can
give a false sense of where the function goes.

Another point, how do you know the graphing calculator is accurate?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"Mike Middleton" < XXXX@XXXXX.COM > wrote in message
news:%23xpYfMY\$ XXXX@XXXXX.COM ...

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

Alberto.
```

```Hi,

Can someone tell me how to go about solving a quartic equation i
Excel?  I know there are add-ins available but I don't want to us
them.

Any help is greatly appreciated. Thanks.

Ra

```

```Hi.
Does anyone written a method which solves quartic equations in an Excel
sheet ?
Th.
```

```Dear ms excel user/programmers:

I hope this question is not repeated before.  But anyway

highly appreciate anyone can tell me how (or hint) to use ms excell
and/or visual c/c++, basic, or octave(emulate matlab) to solve:
(12-x)^2 + y^2 =15^2,
(16+y)^2+x^2=25^2

(by programming or using its built in function)?

that ^2 mean square.

looking to any excel user, mathmatician, and/or programmer's help,
eric,  XXXX@XXXXX.COM

```