LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default How do I chart a function (equation) in excel; not a data series?

I've experimented with your plot manager, and would have mentioned it here,
if I'd remembered it. Obviously it would take out most of the difficulty.

I was merely thinking of the poor user who is unfamiliar with Names and
won't be able to figure out what's wrong when the chart doesn't appear as
expected.

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


"Tushar Mehta" wrote in
message om...
I wrote the add-in, Jon, because simply listing values in a worksheet is
woefully inadequate for some functions. If one doesn't know the shape
of the function, one is left to guess as to what x-values one should
use.

Look at http://tushar-
mehta.com/excel/software/plot_manager/decompiled_help/plot6.html
particularly the subsections on comparing the results of the add-in with
other techniques.

I am also at a loss as to why you would think that entering a function
in one cell and using an add-in is either difficult to implement or
require debugging.

In article ,
says...
While these techniques exist, they are not easy to implement and usually
are
even more difficult to debug. What's wrong with using a worksheet range?
Worksheets are cheap (in terms of memory) and valuable (in terms of what
they show you).

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


"Bernard Liengme" wrote in message
...
Have a look Stephen Bullen's Excel Page at
http://oaltd.co.uk/Excel/Default.htm
under Charting Examples he has a file ChtFrmla.zip that shows all

Other also show how to do this:
Tushar Mehta
http://tushar-mehta.com/excel/softwa...ger/index.html

Jan Karel Pieterse
http://jkp-ads.com/Articles/ChartAnEquation00.htm

best wishes




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can i use the IF function in a chart to choose its data series? Edd UK Charts and Charting in Excel 2 April 2nd 23 07:57 PM
Why does Excel line chart cut off my data series? snowbound Charts and Charting in Excel 4 August 2nd 06 12:19 PM
Can I split data series in an excel chart? AlMorg Charts and Charting in Excel 0 July 5th 06 02:51 PM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM
One data series and two y-axes in an Excel chart? [email protected] Charts and Charting in Excel 1 December 30th 04 03:35 PM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"