I have a chart that is only a Y axis with minimum value of 81.87 and max value of 91.87. Looks like this:
I’d like to modify it in such way that only whole numbers are displayed (82, 83, 84 and so on). Now, I want the numbers to be at their correct place, so in example the 82 should be slightly lower than the current 81.87 mark. I only found a way to show the full numbers in the place of current labels, which in my case just isn’t sufficient.
I found a workaround for this – I could add a new series with Y values of my desired labels and X values of 0, plot them, change the markers to lines and add data labels. This way would get me the result I need, however I was hoping to find a more "elegant" solution. Let me know if you have any ideas!