Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bud Fina
 
Posts: n/a
Default Excel Charts: Can I show standard deviation on selected series?

3D bar chart:
Column 1 has labels
Column 2 has data
Column 3 has calculated Standard Deviation
I need to show one cell from column three as a standard deviation on one of
the data items in Column 2. Can this be done?


  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Bud -

You can apply custom error bars to show a different SD for each point.
Double click the series, click on the Error Bars tab, click in the box
next to Custom +, and select the range with SD values, then click in the
Custom - box, and select this range (use two ranges for different + and
- values). If you used the entire column 3, all the values in column 3
would be used, for the corresponding points in column 2. If you only
wanted one point to have error bars, use Column 4, and keep it blank
except for the value you copied from column 3 (use the whole range in
column 4, even though it's mostly blank).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Bud Fina wrote:

3D bar chart:
Column 1 has labels
Column 2 has data
Column 3 has calculated Standard Deviation
I need to show one cell from column three as a standard deviation on one of
the data items in Column 2. Can this be done?


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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How to change the color of all series in an excel chart in one go. Marielle Charts and Charting in Excel 2 May 3rd 23 07:45 PM
UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 04:58 PM
How to change the color of all series in an excel chart in one go. Mz2 Charts and Charting in Excel 1 January 20th 05 01:07 AM
how do I plot mean and standard deviation in excel amg Charts and Charting in Excel 3 January 6th 05 03:53 AM


All times are GMT +1. The time now is 02:25 AM.

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

About Us

"It's about Microsoft Excel"