plot a chart from formula
 

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

plot a chart from formula
 

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

plot a chart from formula
 

On May 7, 4:21*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
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- Hide quoted text -

- Show quoted text -

Thanks David, I'll do that.

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