Y-axis max +1

[Anonymous]

Hi,

Is there a way to change the Y-Axis to be the max total +1 so that the stacked column chart column grand total shows?

Below is a screenshot of my graph.. Since the Y-Axis's max number is 8, it does not show the grand total for 2019 Nov since the total is close to 8 since there is not enough room in the visualization...

Please let me know if this question does not make sense

Thank you!
Sarah

[Greg_Deckler]

How are you showing the grand total, are you using a stacked column and line chart or is there an option in the stacked column chart that I am missing?

[FrankAT]

Hi @Anonymous ,

select your visual, go to format options, Y axis and enter 9 or 10 into End field.

Regards FrankAT

[Anonymous · Accepted solution]

hi @FrankAT ,but when I select a new filter, the max y-axis changes from 8 to 6 for example... is there a way to change it with each filter?