I've created a pie chart in Google Sheets and used the values as labels. However, they are showing up with a lot of decimals as they are a sum of the referenced columns.

CodePudding user response：

You need an intermediary table with values aggrigated by category

Paste this formula to get intermediary table

=ArrayFormula({C1,B1;  UNIQUE(C2:C), IF(UNIQUE(C2:C)="",,SUMIF(C2:C,"="&UNIQUE(C2:C),B2:B))})

• Duplicate you current chart and change the range to the intermediary table H3:I1000 in this case
• and disable Aggregate in the chart editor > Setup > Lable >