This is just how Excel calculates the minimum and maximum scale. They have
an article about this, which explains how it calculates the min and max, but
not the major unit.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.