The second chart, with one added decimal digit of precision, correctly displays 33.3% for all three wedges. However, the first chart reports percentages of 34%, 33%, and 33%. Each pie wedge is 1/3 of the total, 33.333333…%, rounded to 33%. Both charts below use the same data range, three cells each containing the value 1. This only occurs if the precision of the labels is unit percentages (number format of 0%), not if more precision is allowed (number format of 0.0%). The phenomenon is that Excel will place incorrect percentage labels onto the wedges of a pie chart, simply to ensure that the displayed percentages add to 100. This is a specific illustration of a strange and wonderful phenomenon in Excel pie charts.
I do have one (or more) of those rants posts in me somewhere, but this isn’t one. This isn’t the usual “Pie Charts Suck” entry that we see so many of.
0 kommentar(er)
