• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Setting Y axis major and minor values

In the attached file, I am trying to set the major and minor values for the Y axis and the graph is not displaying like I wanted.

I want the minor increments to be 0.0025 and the major increments would be 1.0 so that the numbers 1 thru 5 would display as the major values and the minor increments would be in denominations of 0.0025.

This involves many minor increments so I have the graph stretched out quite a bit but it still is not working.

I can get the major numbers displayed. Also the minor ticks are turned on. I just need to get Excel to display the values of those minor ticks.

I am using Excel 2016.


POST MOVED BY MODORATER.
 

Attachments

  • Chandoo Y Axis Major and Minor Values.xlsx
    51.4 KB · Views: 6
Last edited by a moderator:
DashboardNovice ...
I just need to get Excel to display the values of those minor ticks.
... something like this?
 

Attachments

  • Chandoo Y Axis Major and Minor Values.xlsx
    48.1 KB · Views: 2
Back
Top