Error bars in Excel?

Gary Rudnick rudnick at biomed.med.yale.edu
Thu Dec 16 12:48:48 EST 1993


In article <gilles.bronchti.9.00111A30 at ia.unil.ch> gilles.bronchti at ia.unil.ch (Gilles Bronchti) writes:
>From: gilles.bronchti at ia.unil.ch (Gilles Bronchti)
>Subject: Re: Error bars in Excel?
>Date: Wed, 15 Dec 1993 17:06:01

Details deleted...

>My explanations might be complicate, but once you learn how to do that, you 
>will see that it works easily, and faster than me writing all these. I am not 
>good in macro writing, but I am sure that all this procedure may be done by 
>macro, providing you give the proper number of the series you want to start 
>the overlay graph. If something is not clear, feel free to contact me by 
>e-mail, I will go to excel and look at the exact commands, name of menu 
etc...>Gilles Bronchti >   

Wow!

I could have used this information about a year ago, when I tried to make 
Excel do the work of a graphing program.  I found that I could get it to fit 
sets of data using the solver function, but I never got the error bars 
working.  As a result I switched to Origin for Windows for fitting and 
plotting and it has been able to take everything we've thrown at it.  The 
program has a few quirks, but for our work, it was much better and faster than 
SigmaPlot for DOS.  I wonder if the windows version is any faster?
================================================================
Gary Rudnick                       |voice (203) 785-4548
Department of Pharmacology         |fax (203) 785-7670
Yale University School of Medicine |bitnet RUDNICK at YALEMED
333 Cedar Street, P.O. Box 208066  |internet:
New Haven, CT 06520-8066           |RUDNICK at BIOMED.MED.YALE.EDU
----------------------------------------------------------------
What separates the men from the boys is the price of their toys.




More information about the Bio-soft mailing list