Add, remove, or change error bars in PivotChart view
Error bars graphically express potential error amounts relative to each data marker in a data series. You can add one set of error bars per series.
-
Open a datasheet or form in PivotChart view.
-
Do one of the following:
Add error bars-
Click a data marker in the data series to which you want to add error bars, and then click again to select the entire series.
-
On the PivotChart toolbar, click Properties
, and then click the General tab. -
Under Add, click Add Errorbar
.
You cannot delete an individual error bar. When you delete one error bar, all error bars for the entire data series are deleted.
-
Click any error bar in the series for which you want to delete error bars.
-
Press DELETE.
When you select an error bar, any changes you make affect all the error bars in its associated data series.
-
Click any error bar in the series for which you want to change settings.
-
On the PivotChart toolbar, click Properties
, and then click the Error Bars tab. -
Do one or more of the following:
-
To select a different type of error bar (plus or minus), click the arrow next to Display
, and then click the type you want. -
To show or hide end caps on the error bars, click the arrow next to Marker
, and then click the type you want. -
To change the method used to determine the error amount, click the method you want in the Error calculation list, and then type the number you want in the Error box or the Percentage box.
-
To change the direction of the error bars so that they calculate based on x-values or y-values for xy (scatter) charts, polar charts, and bubble charts, click X or Y in the Direction list.
-