Number of major ticks of left axis in chart
Hi all,
I'm creating a line chart and on the left axis of this chart I want a 'tick' for every 10, like this:
50
40
30
20
10
0
I know that I can accomplish this by setting the minimum value to 0, the maximum value to 50 and the Number of major ticks to 6. This means that the number of major ticks is related to the maximum value, i.e. number of major ticks = (maximum value / 10) +1.
The problem is that I do not want the maximum value and the number of major ticks to be fixed. I want to reuse the chart in a dashboard an the maximum value of the chart can be 80, 90, 100 or higher. But I still want a major tick for every 10.
So the maximum value on the left axis must be based on the data (which is the normal behavior of the chart). And when it calculates the maximum value it also needs to adjust the number of major ticks.
Does anyone know how to accomplish this?
Cheers,
Stijn