Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Graph of a mathematical function

14 views
Skip to first unread message

Joe

unread,
Jul 16, 2003, 11:00:43 PM7/16/03
to
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

unread,
Jul 17, 2003, 10:42:24 AM7/17/03
to
[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

unread,
Jul 17, 2003, 10:14:17 PM7/17/03
to
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

0 new messages