Horizontal error bars added by default - how to disable?

When adding vertical error bars to scatter plots, Excel automatically adds horizontal error bars.  Is there a way to change this default?  I never use x error bars, but often use y error bars.  On my old computer (Windows XP + Office 2007) I simply deleted them manually a few times and then, somehow, it remembered and they never popped up again, with no other manual intervention.  This isn't happening for my new computer, so I'd love to know how to disable it.



Question Info

Last updated November 27, 2019 Views 43,434 Applies to:

Maybe not "exactly what you want", but it's better than the default.

Another option is to use the Error Bar add-in I wrote for Excel 2007. It makes life much easier (there's also a version for Excel 2003 and earlier which makes life a little easier).

Error Bars in Excel 2007

- Jon
Jon Peltier
Peltier Technical Services, Inc.



MS Excel MVP
Jon Peltier
Peltier Technical Services, Inc.
MS Excel MVP 2001 to now

1 person was helped by this reply


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.