Thread View: sci.stat.math
5 messages
5 total messages
Started by Jan Olivier
Wed, 17 Jun 1998 00:00
EXCEL 7.0 Chart functions
Author: 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 |
---------------------------------
Re: EXCEL 7.0 Chart functions
Author: Gail Pyne
Date: Wed, 17 Jun 1998 00:00
Date: Wed, 17 Jun 1998 00:00
9 lines
1334 bytes
1334 bytes
With excel, you have a separate column with the Standard deviations in it. Select the chart and double click on the data series. Select the "y error bars" tab. Check the box marked "custom" with a + sign in it. Sweep the cursor down the column with the standard deviations in it, and click OK. This should give you the error bars as you described them. Gail Pyne. (biochemist)
Re: EXCEL 7.0 Chart functions
Author: John Mihic
Date: Fri, 19 Jun 1998 00:00
Date: Fri, 19 Jun 1998 00:00
32 lines
2196 bytes
2196 bytes
In article <3587975A.E3DFC7C4@zedat.fu-berlin.de>, janni@zedat.fu-berlin.de says... <<snip>> >Using MS EXCEL 7.0 I'm analyzing statistical data. Those data shall be >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 ? > Microsoft is too busy putting crap into their programs to actually add some useful and functional code once in a while. If you've got Excel 97, try the following and you will be amazed at what Microsoft has stuck in the code you've got running in your computer. No wonder this stuff is called bloatware! (1) Start Excel 97 (on a PC) and open a new blank work sheet. (2) Press F5 and type X97:L97 in the "Reference" box, then click "OK". (3) Now hit the tab key once (you should end up in cell M97). (4) hold down "Ctrl" and "Shift" while clicking once on the "Chart Wizard" icon (the one at the top with the blue-yellow-red bar chart). Move your mouse and press the two mouse buttons. You can exit back to the program by pressing "Esc". Harmless fun you might say, but why the hell would you want all this useless extraneous code taking up space in your RAM and hard drive? John
Re: EXCEL 7.0 Chart functions
Author: John Rivera
Date: Sun, 21 Jun 1998 00:00
Date: Sun, 21 Jun 1998 00:00
16 lines
1508 bytes
1508 bytes
On 19 Jun 1998 17:02:28 GMT, jmihic@wfubcm.edu (John Mihic) wrote: >(1) Start Excel 97 (on a PC) and open a new blank work sheet. >(2) Press F5 and type X97:L97 in the "Reference" box, then click "OK". >(3) Now hit the tab key once (you should end up in cell M97). >(4) hold down "Ctrl" and "Shift" while clicking once on the "Chart Wizard" >icon (the one at the top with the blue-yellow-red bar chart). > >Move your mouse and press the two mouse buttons. You can exit back to the >program by pressing "Esc". In there is a ramp with a list of all the developers who contributed to the program. Kind of like the end of a movie.
Re: EXCEL 7.0 Chart functions
Author: Oliver Bader
Date: Wed, 24 Jun 1998 00:00
Date: Wed, 24 Jun 1998 00:00
37 lines
2567 bytes
2567 bytes
I think it's kind of cute, but how on earth is one supposed to stumble over that freaky combination? Might just as well stick it if they hide it that much John Mihic wrote: > In article <3587975A.E3DFC7C4@zedat.fu-berlin.de>, janni@zedat.fu-berlin.de > says... > > <<snip>> > > >Using MS EXCEL 7.0 I'm analyzing statistical data. Those data shall be > > >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 ? > > > > Microsoft is too busy putting crap into their programs to actually add some > useful and functional code once in a while. If you've got Excel 97, try the > following and you will be amazed at what Microsoft has stuck in the code you've > got running in your computer. No wonder this stuff is called bloatware! > > (1) Start Excel 97 (on a PC) and open a new blank work sheet. > (2) Press F5 and type X97:L97 in the "Reference" box, then click "OK". > (3) Now hit the tab key once (you should end up in cell M97). > (4) hold down "Ctrl" and "Shift" while clicking once on the "Chart Wizard" > icon (the one at the top with the blue-yellow-red bar chart). > > Move your mouse and press the two mouse buttons. You can exit back to the > program by pressing "Esc". > > Harmless fun you might say, but why the hell would you want all this useless > extraneous code taking up space in your RAM and hard drive? > > John
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads