Add error bars to a chart
- Click the data series to which you want to add error bars.
- On the Format menu, click Selected Data Series.
- On the X Error Bars tab or the Y Error Bars tab, select the options you want.
Note If you change the worksheet values or formulas associated with the data points in the series, the error bars are adjusted to reflect your changes.