How do I plot the function 0.95*e^-0.0206*t on a graph in excell?

How do I plot the function 0.95e^-0.0206t on a graph in excell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sean - 13 Sep 2006 04:35 GMT

I can't figure out how to plot the function as a graph? Where do I go? Charts
seem to only work with data.

Reply to this Message

Andy Pope - 13 Sep 2006 09:13 GMT

Hi,

Here are some examples

Stephen Bullen's ChtFrmla
http://www.oaltd.co.uk/Excel/Default.htm

Tushar Mehta's Plot manager
http://tushar-mehta.com/excel/software/plot_manager/index.html

Cheers
Andy

> I can't figure out how to plot the function as a graph? Where do I go? Charts
> seem to only work with data.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Del Cotter - 13 Sep 2006 09:31 GMT

>I can't figure out how to plot the function as a graph? Where do I go? Charts
>seem to only work with data.

The simple answer is to turn your function into data by plugging x
values into the function and reading off the y values, then plotting
those. It's what almost everybody does.

*However*, if you'd like something cuter, Stephen Bullen has a clever
demonstration of the power of named ranges on his website:

http://www.oaltd.co.uk/Excel/Default.htm

>ChtFrmla.zip
>This spreadsheet demonstrates the power arising from using defined
>names as the source for your charts. The example shows how you can plot
>a function, such as y=exp(x)*sin(x^2) over a range of x values, without
>putting them all into separate cells. All the hard work is done in two
>defined names.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message