Vertical Axis Rounding Percentages Up In Stacked Column

CMBaxter
CMBaxter ✭✭
edited 08/23/23 in Smartsheet Basics

I have a stacked column chart on a Dashboard. The categories are all percentages that should amount to ~100% when summed (stacked). The vertical axis seems to be rounding the percentages to whole numbers; you can see that the grid lines that should be 20% and 40% are both rounded down to 0, where the grid lines for 60% and 80% are rounded up to 1.

When I hover over any category, it shows the data for that category as a percent. The corresponding columns for the categories are all formatted as percentages on the source sheet. How can I get the vertical axis to show percentages, or at the very least not round up the decimal places (e.g. more significant figures)?

Answers