View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default plot a chart from formula

Actually you can, as examples on Stephen Bullen's, Tushar Mehta's, and Jan
Karel Pieterse's web sites all demonstrate. They use dynamic names which
incorporate the formulas. In my experience, these techniques are good for
showing someone how clever you are, but they are a bugger to set up, debug,
and maintain. Keep it simple, sluggo, and use the cells that Excel has at
its disposal.

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


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
You can't. An Excel graph is plotted from numbers, so you need to give it
the numbers to plot. Use the formula to generate the numbers.
--
David Biddulph

wrote in message
...
Hi all:

Can anyone tell me how to plot a formula without data ? I mean for
example y = x^2, and show the result in a graph ?
Thanks for your help

JC