RE: 2dColumn (Clustered Column) chart with Standard Deviation Bars
 From: Shane Devenshire <ShaneDevenshire@xxxxxxxxxxxxxxxxxxxxxxxxx>
 Date: Fri, 28 Nov 2008 14:45:01 0800
Hi,
Select the series, choose Format, Selected Data Series, Y Error Bars tab,
pick Both under display and Standard deviations under error amount.
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Gary T" wrote:
I have a 2D clustered column chart that shows the mean value of 4 different.
samples using chunky blue coloured bars.
What I would also like to do is, on the same graph, show the standard
deviation of each sample on the relevant blue bar, such that a vertical line
is inserted in the middle of each of the blue bars that shows 1 standard
deviation up the way and one standard deviation down the way (i.e. so that it
looks like 2 letter "T"'s, symmetrically above and below each other).
I've not explained that very well but I hope someone knows roughly what I'm
trying to do  its really a typical statistical chart that shows both mean
and standard deviation on the same graph.
I can post an image if this site allows and if it would be useful.
Regards
 References:
 Prev by Date: RE: XY Labeler and Excel 2007
 Next by Date: RE: Auto Scale xaxis
 Previous by thread: 2dColumn (Clustered Column) chart with Standard Deviation Bars
 Index(es):
Relevant Pages
