# How do I make a pie chart with 100% of percentage of de data?

Hello! I am trying to make a pie chart, but the sum of the percentages is always 99% or 101% for example. How do I solve it? It seems it doesn't have a tool that corrects an uneven number.

• ✭✭✭✭

Smartsheet would round the percentage off. There is a scenario where the value after the decimal of all numbers are less than 0.5 (in your example, 0.13, 0.15, 0.48 & 0.24), which would result in sum of percentage being 99%. In order to workaround this, you may want to derive the percentage by yourself in a metric sheet. For example,

After that, add the pie chart based on the figures you derived.

• ✭✭✭✭

Smartsheet would round the percentage off. There is a scenario where the value after the decimal of all numbers are less than 0.5 (in your example, 0.13, 0.15, 0.48 & 0.24), which would result in sum of percentage being 99%. In order to workaround this, you may want to derive the percentage by yourself in a metric sheet. For example,

After that, add the pie chart based on the figures you derived.

• Thanks a lot! Yes, I guess Smartsheet doesn't do that automatically, so I will have to do it manually.

• Depending on the tool you're using and the number of decimal places displayed, the percentages might be slightly rounded. For instance, the sum of several slices might show as 99% due to rounding down on individual percentages.
If you have a category that wasn't included in the data used to create the pie chart, it wouldn't be represented by a slice. This could make it seem like the percentages don double-check your data to ensure all categories are accounted for.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!