Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 28th 08, 08:24 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 21
Default 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   Report Post  
Old November 28th 08, 10:45 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need help with a standard deviation chart. pm Excel Discussion (Misc queries) 2 April 17th 08 09:19 PM
Standard deviation of specific cells in a column Schwartz Excel Discussion (Misc queries) 1 April 4th 07 12:06 PM
Needed: Chart that combines clustered column and stacked column types Gerry Charts and Charting in Excel 3 February 14th 07 02:53 AM
Combined: Clustered-Stacked Column Chart cdo Charts and Charting in Excel 1 August 31st 05 01:46 AM
combination clustered column and stacked bar chart John Charts and Charting in Excel 2 April 19th 05 03:49 PM


All times are GMT +1. The time now is 03:46 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017