Microsoft® Office Excel® 2007 Inside Out

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 ...