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