Scatter chart parabola

C

cpopham

I am attempting to use Excel for my BA class. I have a quadratic
function which gives me a parabola. However, when I try to graph it in
excel instead of the parabola opening up or down it opens sideways. The
points are correct, the connecting lines are what is not correct. How
can I fix this so that the parabola will go through the points the
correct way and open downward instead of sideways?

my points are as follows
x y
9 387
0 144
-6 0
24 0


Thanks, Chester
 
J

John Mansfield

Chester,

Rearrange your points on your XY scatter chart as follows:

x y
-6 0
0 144
9 387
24 0
 
C

cpopham

Thank you for the help. I thought that Excel would be able to determine
which way the parabola would go according to my formula.

Chester
 
J

Jon Peltier

Chester -

Excel is not capable of doing what you want it to do, only what you tell
it to do. The points are plotted in the order they appear in the table.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top