Windows Guides Feed

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.

Say we have a spreadsheet containing daily sales figures.

daily sales figures Change the Default Axis Interval in an Excel Chart [How To]

The chart produced from this data would look like this:

daily sales amount Change the Default Axis Interval in an Excel Chart [How To]

Now, admittedly, that isn’t bad, but we can make the chart much more meaningful if we tweak that axis, right?

tweak that axis Change the Default Axis Interval in an Excel Chart [How To]

This is a little easier to work with I would say. How did we make that tweak?

The trick is to set up your chart then right-click the axis, then on the context menu that appears we click the axis formatting option.

axis formatting option Change the Default Axis Interval in an Excel Chart [How To]

From there you get to choose from lots of options, switching from the automatic defaults to settings you choose.

settings you choose Change the Default Axis Interval in an Excel Chart [How To]

These are the settings I used above:

used above Change the Default Axis Interval in an Excel Chart [How To]

Summary

As you can see, while the defaults are not always exactly what we want, Excel usually does allow you to change them. The challenge is often knowing where the settings are hidden!

About the author

Yoav Ezer co-authors the technology and productivity blog Codswallop. He is also the CEO of a company that produces PDF to Excel conversion software.

For more Excel tips from Yoav, join him on Facebook or Twitter



 Change the Default Axis Interval in an Excel Chart [How To]

About Rich

Rich is the owner and creator of Windows Guides; he spends his time breaking things on his PC so he can write how-to guides to fix the problems he creates.

Free PC tips by email

Search Windows Guides




Comments

  • Klito 00

    Thank You!!!!

  • Anonymous

    You welcome..


Computer tips in your inbox
Sign up for the Windows Guides newsletter to get PC tips and access to free Windows books (More details)

Enter your email address:
 

Popular Guides

See which sites have been visited on your PC (even if private browsing mode is used)

Create a Windows 7 System Repair Disc

Best Free Anti-malware

Hibernate vs. Sleep vs. Shut-Down

i3, i5, and i7; Dual, Quad, Hexa Core Processors. How to they Differ?

Intel's Ivy Bridge Processor: new Features

Submit Your Tip
Submit your computer tip to us; receive full credit for all published tips

Windows Guides on Facebook