How can I make an excel chart based on an equation?

On Fri, 10 Aug 2007, in microsoft.public.excel.charting,
Daniel said:

How can I make an excel chart based on an equation?

Your equation will be in the form y=f(x). Create two columns, one of
which is filled with values of x, and the other filled with copies of
the equation f as an Excel formula, referring to the x values. Now make
an XY Chart using these two columns.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Since this is such a common request, I wrote this tutorial last month:

http://peltiertech.com/Excel/ChartsH...tEquation.html

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


"Del Cotter" wrote in message
...
On Fri, 10 Aug 2007, in microsoft.public.excel.charting,
Daniel said:

How can I make an excel chart based on an equation?

Your equation will be in the form y=f(x). Create two columns, one of which
is filled with values of x, and the other filled with copies of the
equation f as an Excel formula, referring to the x values. Now make an XY
Chart using these two columns.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.

Thanks, Are there any other method to create chart without filling out x and
y columns in excel?
I know some statistic software such as Systat, plot chart just one click
after fill out the equation.
Thanks again
Daniel


"Jon Peltier" wrote:

Since this is such a common request, I wrote this tutorial last month:

http://peltiertech.com/Excel/ChartsH...tEquation.html

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


"Del Cotter" wrote in message
...
On Fri, 10 Aug 2007, in microsoft.public.excel.charting,
Daniel said:

How can I make an excel chart based on an equation?

Your equation will be in the form y=f(x). Create two columns, one of which
is filled with values of x, and the other filled with copies of the
equation f as an Excel formula, referring to the x values. Now make an XY
Chart using these two columns.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.

Jon's article contains links to pages demonstrating a similar technique
for Excel, if that's what you want to do.

Daniel said:
Thanks, Are there any other method to create chart without filling out
x and y columns in excel? I know some statistic software such as
Systat, plot chart just one click after fill out the equation.

"Jon Peltier" wrote:
Since this is such a common request, I wrote this tutorial last month:

http://peltiertech.com/Excel/ChartsH...tEquation.html

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

These techniques are initially pretty cool, until you're trying to track a
bug in a formula somewhere. Since you can't examine the data except in the
plot, you're in a difficult spot.

Worksheet cells are cheap and easy to use. If people didn't try to get
around using them for whatever reason, they'd have many fewer charting
difficulties.

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


"Del Cotter" wrote in message
...
Jon's article contains links to pages demonstrating a similar technique
for Excel, if that's what you want to do.

Daniel said:
Thanks, Are there any other method to create chart without filling out x
and y columns in excel? I know some statistic software such as Systat,
plot chart just one click after fill out the equation.

"Jon Peltier" wrote:
Since this is such a common request, I wrote this tutorial last month:

http://peltiertech.com/Excel/ChartsH...tEquation.html

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.