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;
- Nov 21 Wed 2007 20:40
How can I draw a Parabola in Excel? like y = x^2 3
close
全站熱搜
留言列表
發表留言