Vertical Axis Rounding Percentages Up In Stacked Column
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
-
Are you able to provide a screenshot of the data you are using to populate the chart?
