Article View: sci.stat.math
Article #59EXCEL 7.0 Chart functions
From: Jan Olivier
Date: Wed, 17 Jun 1998 00:00
Date: Wed, 17 Jun 1998 00:00
37 lines
2124 bytes
2124 bytes
Hi to everybody!
I'M SORRY FOR MY BAD ENGLISH!
Using MS EXCEL 7.0 I'm analyzing statistical data. Those data shall be
displayed in a columnar diagram. Since weeks I'm looking for a
possibility to add bars for the standart deviation and/or the standart
error ( 'error bars' )to my columns. The problem is not calculating the
standart deviation or the standart error, the problem is adding this
information to my graphics.
The style I'm looking for:
_
|
| <--- 'extra' bar ( e.g. 'error-bar')
__|__
| |
| | <--- 'normal' coulmn ( e.g. representing 'mean' )
| |
______|_____|__ <--- X-Axis
If anybody knows a way to do this kind of graphics with EXCEL please,
please mail me immedeately... (I know lots of programms to do this stuff
but only EXCEL is what really would help me...)
Perhaps there is some Makro or an Add-in ?
Thanks in advance ... joo
--
_________________________________
| mailto:janni@zedat.fu-berlin.de |
| Jan Oliver Olivier ----- 1998 |
---------------------------------
Technical Details
Message-ID:
<3587975A.E3DFC7C4@zedat.fu-berlin.de>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10d632,a7aa3bb86af0a184,start X-Google-Attributes: gid10d632,public X-Google-Thread: 105e35,a7aa3bb86af0a184,start X-Google-Attributes: gid105e35,public X-Google-Thread: 111b91,a7aa3bb86af0a184,start X-Google-Attributes: gid111b91,public X-Google-Thread: f732f,a7aa3bb86af0a184,start X-Google-Attributes: gidf732f,public X-Google-Thread: fa6b6,a7aa3bb86af0a184,start X-Google-Attributes: gidfa6b6,public From: Jan Olivier <janni@zedat.fu-berlin.de> Subject: EXCEL 7.0 Chart functions Date: 1998/06/17 Message-ID: <3587975A.E3DFC7C4@zedat.fu-berlin.de> X-Deja-AN: 363471442 Content-Transfer-Encoding: 7bit Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: fu-berlin.de 898078541 20506 (none) 160.45.231.86 Organization: FU Berlin X-Access: 16 17 19 Newsgroups: sci.stat.math,sci.stat.edu,sci.stat.consult,bionet.biology.cardiovascular,bionet.software