ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how to add erro bars for each bar, rather than the whle series (https://www.excelbanter.com/charts-charting-excel/158644-how-add-erro-bars-each-bar-rather-than-whle-series.html)

Lumos

how to add erro bars for each bar, rather than the whle series
 
I want to have error bars added to each bar, based on that bar's standard
error.
The only think that I can find excel letting me to do is add some number to
all bars of a series.

is there a way to add calculated error bars for each individual bar in a
graph?

Thansk

Jon Peltier

how to add erro bars for each bar, rather than the whle series
 
Error bars:

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

The trick is to calculate the values in a worksheet range parallel to the
series values, then use these calculations as the source for your custom
error bar values.

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


"Lumos" wrote in message
...
I want to have error bars added to each bar, based on that bar's standard
error.
The only think that I can find excel letting me to do is add some number
to
all bars of a series.

is there a way to add calculated error bars for each individual bar in a
graph?

Thansk





All times are GMT +1. The time now is 10:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com