Display only max and min value on y-axis

[htgdds01]

Hello, how can I set the value y-axis like in this picture with only min and max, instead of showing 0.0, 0.1,...,0.5? Thank you.

[LeandroDeodato]

I didn´t understand your problem, do you want to display complete values? if so, in the gaph value settings,  you can change the display unit.

[htgdds01]

My y-axis shows 5 values: 0.0, 0.1, 0.2, 0.3, 0.4, 0.5, I want it show only min and max value which is 0.0 and 0.5 like that in the picture. Thank you

[NaveenGandhi · Accepted solution]

@htgdds01 

You can't conditional format the y axis, So its not possible to implement want you want. But a simple way would be turn off the y axis labels and add two text box with dynamic min and max numbers.

It is a crude way of doing it. But let me know your thoughts.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!