Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Y-axis max +1

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

  • Anonymous's avatar
    Anonymous
    6 years ago

    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?

3 Replies

  • FrankAT's avatar
    FrankAT
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous ,

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

    Regards FrankAT

    • Anonymous's avatar
      Anonymous
      Not applicable

      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?

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    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?