Calculate and display individual error bars for individual points

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

del - 30 Mar 2006 22:57 GMT

Generally error bars (standard deviations) vary point-by-point in a graph
depending on the distribution of individual values for each point. Excel can
calculate these separate standard deviations, but there appears to be no way
to display them in a graph. Has anyone found a way around this?

Reply to this Message

Jon Peltier - 31 Mar 2006 04:24 GMT

You can easily apply custom error bars to a series. I describe how here:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

> Generally error bars (standard deviations) vary point-by-point in a graph
> depending on the distribution of individual values for each point. Excel
> can
> calculate these separate standard deviations, but there appears to be no
> way
> to display them in a graph. Has anyone found a way around this?

Reply to this Message