Change error bar settings

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

  1. Click the data series that has the error bars you want to change.

  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.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.