🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.os.msdos.apps
Article #3076

Error Bars in Excel

#3076
From: Wilf Rosenbaum
Date: Wed, 26 Jun 1991 16:26
25 lines
1532 bytes
Last week someone posted a request to this group (I think) for 
information on creating a chart in Excel which showed error bars.
Unfortuately I lost the original article and address. Anyhow here is
one method:
 
 1. Select the data series in the work sheet that you want to chart.
    Create a new chart showing this data. There should be three series
    plotted, say the y series (the data itself), the yh series (the
    upper y limit values) and yl (the lower limit values).

 2. Select Format|Main Chart from the chart menu. Set the chart type 
    as Line, and select the Hi Low Lines check box. Press Enter to 
    accept these options.

 3. Make the yl and yh series invisible by using selecting the series
    choosing the Format | Series (?) command and making the line
    styles invisible. This must be done separately for each of the
    yl and yh series. 

 4. You'll probably want to change the displayed symbols on the 
    yl and yh series to the small '-' character.

    Hope this helps.
    Wilf Rosenbaum
    rosen@cs.sfu.ca
Technical Details
Message-ID: <1991Jun26.162635.3624@newsserver.sfu.ca>
Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!mips!atha!aunro!alberta!brazeau.ucs.ualberta.ca!unixg.ubc.ca!ubc-cs!newsserver.sfu.ca!rosen

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!mips!atha!aunro!alberta!brazeau.ucs.ualberta.ca!unixg.ubc.ca!ubc-cs!newsserver.sfu.ca!rosen
From: rosen@newsserver.sfu.ca (Wilf Rosenbaum)
Newsgroups: comp.os.msdos.apps
Subject: Error Bars in Excel
Message-ID: <1991Jun26.162635.3624@newsserver.sfu.ca>
Date: 26 Jun 91 16:26:35 GMT
Distribution: comp
Organization: Simon Fraser University, Burnaby, B.C., Canada
Lines: 25