Adding Error Bars


When you plot statistical or experimental data, it's often helpful to indicate the confidence level of your data. The Excel error-bar feature makes this easy. To add error bars to a data series in an area, bar, column, line, or X Y (scatter) chart, select the series. Then click the Layout tab, and click Error Bars (the last item on the right side of the Ribbon). As with trendlines, unless your intention is to remove existing error bars (in which case you'll click None), there's little point in resting your pointer on the options that drop down from the Ribbon; instead, click More Error Bars Options to get to the dialog box shown in Figure 20-24. Here you can tailor your error bars and specify the range of values you want them to encompass.

image from book
Figure 20-24: You can customize error bars for direction, style, and amount.



Microsoft Office Excel 2007 Inside Out
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
Year: 2004
Pages: 260

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net