Change error bars

Office Web Component Chart

Change error bars

When you select an error bar, any changes you make affect all the error bars in its associated data series.

  1. In the design window, make sure the chart is activated. For instructions, see Help for your design program.
  2. Click any error bar on your chart.
  3. On the chart toolbar, click Commands and Options , and then click the Error Bars tab.
  4. Do one or more of the following:
    • To show or hide end caps on the error bars, click the arrow next to Display , and then click the type you want.
    • To select a different type of error bar (positive or negative or both), 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.