make chart based on equation

[Daniel]

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

 

[Del Cotter]

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.

 

[Jon Peltier]

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

http://peltiertech.com/Excel/ChartsHowTo/PlotEquation.html

- Jon

 

[Daniel]

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

 

[Del Cotter]

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

 

[Jon Peltier]

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

 

[Raget]

What if you wanted to display a chart that tested values on one cell (being
x) and then plotted the y values. I want to do this because I have a
complicated spreadsheet, and instead of a simple equation, the path leads
through various sheets etc.
Or can you have a separate sheet that tests, for example if A1 equals one,
it will display what C4 will equal. Then if A1 = 2 it displays what C4 will
equal, etc.
I hope that makes sense.

 

[Jon Peltier]

You could set up a data table:

An overview of data tables in Excel 2003 and in Excel 2007 (Microsoft)
http://support.microsoft.com/kb/282852

Data Table Basics (Daily Dose)
http://www.dailydoseofexcel.com/archives/2004/09/15/data-table-basics/

Automating without code (Dermot Balson)
http://www.westnet.net.au/balson/ModellingExcel/LookMaNoCode.shtml

- Jon