How to handle rounded percentage in stacked bar chart not adding to 100%

[engxiong]

Hi All,

I am wondering is there a way to display the stacked bar percentage values to be 100% (instead of displaying rounded % for each bar)

In my chart, the last month oct 2021 is showing 101% in total, but the actual % values in decimals actually sum up to 100%. Another example would be for Aug 2021, it is showing 99% instead of the actual values of 100%

I have uploaded the raw data % for reference to illustrate what i meant as I do not wish to show more decimal places on the chart.

Hope someone can shed light on how to handle such display issues..

Many thanks.

Cheers,

EX

[abhijitnalekar]

Hi @engxiong,

like to understand the requirement a little more.

is fine for you to show decimal to up to 2?

[engxiong]

Hi Abhijit,

Nope, I would like to display in rounded percentages. Hence, I am wondering whether there is a good way to avoid them not summing up to 100% in the display values?