Part III: Creating Charts and Graphics
462
FIGURE 19.23Three options for dealing with missing data.
To add error bars, select a data series and then choose Chart Tools ➪ Layout ➪ Analysis ➪ Error
Bars. This drop-down control has several options. You can then fine-tune the error bar settings
from the Format Error Bars dialog box. The types of error bars arel (^) Fixed value: The error bars are fixed by an amount that you specify.
l Percentage: The error bars are a percentage of each value.
l (^) Standard Deviation(s): The error bars are in the number of standard deviation units that
you specify. (Excel calculates the standard deviation of the data series.)
l (^) Standard Error: The error bars are one standard error unit. (Excel calculates the standard
error of the data series.)
l (^) Custom: You set the error bar units for the upper or lower error bars. You can enter either
a value or a range reference that holds the error values that you want to plot as error bars.
The chart shown in Figure 19.24 displays error bars based on percentage.
Tip
A data series in an XY chart can have error bars for both the X values and Y values. n