How can I draw a Parabola in Excel? like y = x^2 + 3

R

Ron Coderre

Try this:

A2: -40
Select A2:A100

Edit|Fill|Series
Step Value 1...complete the series

B1: PlotData
B2: =A2^2+3
Copy/Paste that formula down through B100

Select B1:B100
Insert|Chart
Choose a line chart and follow the steps.

Does that help?

Regards,
Ron
 
R

Ron Coderre

Try this:

A2: -40
Select A2:A100

Edit|Fill|Series
Step Value 1...complete the series

B1: PlotData
B2: =A2^2+3
Copy/Paste that formula down through B100

Select B1:B100
Insert|Chart
Choose a line chart and follow the steps.

Does that help?

Regards,
Ron
 
R

Ron Coderre

Try this:

A2: -40
Select A2:A100

Edit|Fill|Series
Step Value 1...complete the series

B1: PlotData
B2: =A2^2+3
Copy/Paste that formula down through B100

Select B1:B100
Insert|Chart
Choose a line chart and follow the steps.

Does that help?

Regards,
Ro
 
R

Ron Coderre

Try this:

A2: -40
Select A2:A100

Edit|Fill|Series
Step Value 1...complete the series

B1: PlotData
B2: =A2^2+3
Copy/Paste that formula down through B100

Select B1:B100
Insert|Chart
Choose a line chart and follow the steps.

Does that help?

Regards,
Ron
 
R

Ron Coderre

Try this:

A2: -40
Select A2:A100

Edit|Fill|Series
Step Value 1...complete the series

B1: PlotData
B2: =A2^2+3
Copy/Paste that formula down through B100

Select B1:B100
Insert|Chart
Choose a line chart and follow the steps.

Does that help?

Regards,
Ron
 
R

Ron Coderre

Try this:

A2: -40
Select A2:A100

Edit|Fill|Series
Step Value 1...complete the series

B1: PlotData
B2: =A2^2+3
Copy/Paste that formula down through B100

Select B1:B100
Insert|Chart
Choose a line chart and follow the steps.

Does that help?

Regards,
Ro
 
B

Beege

Column A

A1 - Make it X
A2 - place a negative number, like -10 or-100
A3 - next number in sequence, like -9 or -99
select the two numbers, and drag down until your at 10 or 100

B - Make it Y
B2 put in formula, =A^2+3
Drag down to bottom of range

Graph with lines, or smooth lines. OK?

Beege
 
M

Max

No

I want to enter the formula and then excel must draw me a accurate parabola.
I don't to enter each point by itself.

Is it possible to do it like that?
 
R

Ron Coderre

Sorry about the multiple posts...the ExcelTip forum had issues.


***********
Regards,
Ron

XL2002, WinXP-Pro
 
R

Richard Buttrey

No

I want to enter the formula and then excel must draw me a accurate parabola.
I don't to enter each point by itself.

Is it possible to do it like that?
Click to expand...

One way or another you are going to have to create a range of x values
for the formula to evaluate and chart.

Probably the nearest you can get is to specify the formula and the
upper and lower bounds of an x range, then have a macro go off and
generate the data and chart it.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top