Please forgive me if I don't describe my problem accurately, I've been forced into this and I haven't used excel for many years.
I have several survey responses that I'm trying to make pie charts out of. I have mapped these to a pivot table, I think correctly, and now I'm trying to make pie charts for each question.
What I can't solve for the life of me, is how to perform rounding at the percentage values that adds up to 100. Here is one sample.
If I format the number to 0 decimals, the percentages add up to 99%. If I try to ROUNDUP the pivot table value cells I get "You cannot edit the formula for a calculated item while custom calculations is used". I don't want to write them by hand because there's several questions.
Accuracy doesn't really matter either. If I can push the highest percentage to fill the rest up to 100, I'm fine with that!
Thank you for any help!
PS: I'm so happy Excel forum still exists! I used it first around 10 years ago, and it's the only website that remembers me every year on my birthday!
Bookmarks