close



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--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=521775
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--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=521775
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--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=521775
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--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=521775
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--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=521775
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--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=521775Column 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

quot;Maxquot; gt; wrote in message
...
gt;
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?
Sorry about the multiple posts...the ExcelTip forum had issues.***********
Regards,
Ron

XL2002, WinXP-Proquot;Ron Coderrequot; wrote:

gt;
gt; Try this:
gt;
gt; A2: -40
gt; Select A2:A100
gt;
gt; Edit|Fill|Series
gt; Step Value 1...complete the series
gt;
gt; B1: PlotData
gt; B2: =A2^2 3
gt; Copy/Paste that formula down through B100
gt;
gt; Select B1:B100
gt; Insert|Chart
gt; Choose a line chart and follow the steps.
gt;
gt; Does that help?
gt;
gt; Regards,
gt; Ron
gt;
gt;
gt; --
gt; Ron Coderre
gt; ------------------------------------------------------------------------
gt; Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
gt; View this thread: www.excelforum.com/showthread...hreadid=521775
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()