View Single Post
  #6   Report Post  
Jon Peltier
 
Posts: n/a
Default

Put the set of SD values into a range, and use this range as the source
for custom error bar values. Check out this page for more info:

http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

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


KSkarupski wrote:

CarlosPharm.D: did you ever find out how to do this? I think it's a conspiracy.

"carlosPharm.D" wrote:


I have means of values that are in a line chart. I want to add error bars,
however when I add the error bars with SD=1 they all look the same. I know
the SD for each mean is not the same. I want to know how to get the error
bars to represent the SD of the data set (the set from which the mean was
derived) and not all look the same.