Graph of a mathematical function

[Joe]

I've read somewhere that it is possible to plot a graph of
a math function by supplying the name of the fomula to the
series instead of the range with data. Can anyone give a
simple and instructive example? Thanks!

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting with an
email copy to Joe.
Please use the newsgroup for further discussion.]

Each of the below has its advantages and disadvantages:

* http://www.bmsltd.co.uk/excel/SBXLPage.asp#Charting and look for
ChtFrmla.zip

* the Plot Manager add-in available from my web site.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <006001c34c0f$9c7b90f0$a001...@phx.gbl>, har...@net.hr
says...

[Jerry W. Lewis]

David Braden has posted VBA code to extract the coefficients directly
from the chart into cells

http://groups.google.com/groups?selm=dbraden-1C662A.14054705032003%40msnews.microsoft.com

Eric Desart has published a package

http://www.acoustics-noise.com/Excel/Add-In-Functions.shtml

that independantly compute the trendline equation, and is better
numerically than LINEST, though not as good as the chart trendline.

Jerry