Recipe 4-14. Displaying Error Bars

Displaying Error Bars

Problem

You want to display error bars on data series in your charts.

Solution

You can display error bars for a series by opening the Format Data Series dialog box. Select the series and press Ctrl-1. Click the Y Error Bars tab to specify how you'd like the error bars displayed. You can choose to display plus or minus bars or both. Further, you can specify the error as a fixed value, a percentage of the value being plotted, or as custom values in a cell range you provide. Figure 4-20 (in Recipe 4.9) shows an example data series with error bars.