Format axis on chart on dashboard

cgoodenough ✭✭
edited 11/11/21 in Smartsheet Basics

I have a stacked bar chart that is budget consumed/remaining. I do not want to show any decimal places on the x-axis labels. I have changed the number of decimals in the sheet from which I'm pulling the data, I've even made it No Currency but only the $ disappeared, not the .00s. How do I make those go away?

Thanks in advance.



  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @cgoodenough

    Is it possible that even one cell in that column that's being referenced in the Chart still has the decimal formatting applied? If there's one cell with 6.00 and another cell with 5, the Chart Widget will default to the decimals showing, so it will show both 6.00 and 5.00 in the labels.

    Try highlighting the entire column and then adjusting the decimals in the toolbar menu to ensure all of the cells are formatting the same.

    Then I would suggest (after saving), try logging out of Smartsheet and log in again to see if your Dashboard updated. It should update right away, but logging out/in again may help it recognize the change.