In this guest article, Yoav Ezer shows you how to change the default axis interval in a chart in Microsoft Excel. Find out more about Yoav at the end of this article.
Microsoft Excel is pretty clever and usually the default choices it provides you are good, but sometimes it can be frustrating when it tries to help you and you can not find a way to alter the choices it makes.
Chart axis options are a common example of these frustrations. People often ask us how to override the default Axis Interval. Here is the solution for how to do that.