O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding Error Bars

When you chart statistical or experimental data, it's often helpful to indicate the confidence level of your data. Excel's error bar feature makes this easy. To add error bars to a data series in an area, bar, column, line, or xy (scatter) chart, select the series, choose Format, Selected Data Series, and then click the Y Error Bars tab, shown in Figure 26-13.

Using the Format Data Series dialog box, you can customize error bars to illustrate the potential error for each data point in a series.

Figure 26-13. Using the Format Data Series dialog box, you can customize error bars to illustrate the potential error for each data point in a series.

You can set error bars to show the actual data point value plus some number, minus some number, or both plus and minus some ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required