Graphing in MS Excel

[unknown id]

Hey guys, could u please instruct me as to how to draw a graph of this function on MS Excel:

y=12(1-e^(-x/58.75))?

Thanks in advance!

[AppleXY]

Hey man, Instead of using Excel use a graphing program if you just purely want to show a graph.

Free ones are:

Graphmatica
http://www.mathgv.com/
or Grapher in built in Mac OS X

If you really want to use Xcel -- try and obtaining the output for certain amount of x values and then graph [you could use a calc]

[Collin Li]

I'm not really sure whether MS Excel graphs continuous functions for you, but what you could do is use the A column as the 'X' variable, and the B column as the 'Y' variable.

Fill column A with your desired domain. For example, if you want to graph it from 0 to 10, make A1 '0', A2 '0.1', and then all the way up to '10.' You can make the stepsize/resolution whatever you like. It could be 0.1 each cell, or 1 each cell... the smaller it is, the more processing power is required but the smoother your graph will look.

In B1, type '=12*(1-EXP(-A1/58.75))' and then fill down so that it gives you the Y value for the X value (in column A) corresponding to it. Now, you can graph all those data points. Highlight all your data, create a graph, and pick XY (Scatter), or something like that.

Since you go to MHS: when you are expected to do graph printouts, they usually recommend Graphmatica. It is freely downloadable on the Internet.

[AppleXY]

lol, I think you mean this site:

http://www8.pair.com/ksoft/

[Collin Li]

lol, I think you mean this site:

http://www8.pair.com/ksoft/

It is!

Your post: Today at 09:51:07 AM

Code: [Select]

[url=http://www8.pair.com/ksoft/]Graphmatica[/url]. It is freely downloadable on the Internet.

« Last Edit: Today at 09:49:05 AM by coblin »

[excal]

Excel is capable of graphing functions and the ilk, but you'd most likely will need a 3rd party plugin.

[unknown id]

ok thanks for the replies guys. just d/led graphmatica and everything seems much easier now.

[bturville]

i just found grapher in osx.

im quite impressed actually, the equation inputting part is very simple and intuitive, means i don't have to learn latex or anything. also, you can copy paste from the equation input line to any other program!

[AppleXY]

Yeah, I always use the grapher in OSX. It's seriously some mad stuph, it makes drawing graphs actually simple and sexc!