Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2d-Column (Clustered Column) chart with Standard Deviation Bars
I have a 2-D 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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2d-Column (Clustered Column) chart with Standard Deviation Bars
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 2-D 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help with a standard deviation chart. | Excel Discussion (Misc queries) | |||
Standard deviation of specific cells in a column | Excel Discussion (Misc queries) | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
Combined: Clustered-Stacked Column Chart | Charts and Charting in Excel | |||
combination clustered column and stacked bar chart | Charts and Charting in Excel |