Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XY Scatter Charts, High/Low bars, Multiple Series | Charts and Charting in Excel | |||
find last row and select whle row for format | Excel Discussion (Misc queries) | |||
off-setting points of different series b/c error bars overlap | Charts and Charting in Excel | |||
How do I set different error bars per data point in a series | Charts and Charting in Excel | |||
Y-Bars for Columns in a series | Charts and Charting in Excel |