Show All

Change error bar settings

1. Click the error bar or data series that has the error bars you want to change. When you select an error bar, any changes you make affect all of the error bars in its associated data series.
2. On the Format menu, click Selected Data Series.
3. Click the Y Error Bars tab or the X Error Bars tab, depending on the type of error bars you want to change.

   • To select a different type of error bar, click the type you want under Display.

   • To change the method used to determine the error, select the method you want under Error amount.

   • To change a custom error amount, click Custom. In the Plus and Minus boxes, specify the worksheet range to use as error amount values, or enter the values you want to use, separated by commas; for example, 0.4, 0.3, 0.8.