Pie Chart over 100%

[08rhailer]

I have a workbook that all the sheets in it using a pie chart are adding up to over 100%. I thought this was supposed to adjust automatically to 100%, if anyone has seen or dealt with this then any help will be much appreciated..

 

[Andrew Poulsom]

Welcome to the Board.

Right click the chart and choose Chart Options. On the Data Labels tab what is checked? If it's Percentage the percentages will add up to 100%. If it's Value and the series contains percentages they need not add up to 100%, because only the actual amounts plotted are shown.

 

[08rhailer]

category name and percentage are the only two checked off. All of the charts in the wkbook are adding up to 105%; did not even know making this error was possible?

 

[08rhailer]

All charts in wkbook are off the same template i forgot to say

 

[Andrew Poulsom]

Very strange. Can you post some sample data that adds up to 105% when plotted?

 

[08rhailer]

It varied in each workbook, but i think im just gonna chalk it up to software problem on my end and rewrite it in fresh wkbook. THanks anyways