Article View: comp.os.msdos.apps
Article #3076Error Bars in Excel
From: Wilf Rosenbaum
Date: Wed, 26 Jun 1991 16:26
Date: Wed, 26 Jun 1991 16:26
25 lines
1532 bytes
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!rosenShow 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