Part III: Creating Charts and Other Visualizations
FIGURE 21.24
Three options for dealing with missing data
Normally, a chart doesn’t display data that’s in a hidden row or column. You can use the Hidden and Empty Cell
Settings dialog box to force a chart to use hidden data, though.
Adding error bars
Some chart types support error bars. Error bars often are used to indicate “plus or minus”
information that reflects uncertainty in the data. Error bars are appropriate for area, bar,
column, line, and XY charts only.
To add error bars, select a data series and then click the Add Elements icon to the right of
the chart. Add a check mark next to Error Bars. Click the arrow next to the Error Bars item
to specify the type of error bars. If necessary, you can fine-tune the error bar settings from
the Format Error Bars task pane. The types of error bars are as follows:
Fixed value The error bars are fixed by an amount that you specify.
Percentage The error bars are a percentage of each value.
