PDA

View Full Version : Solved: Pie chart Percentages



austenr
10-20-2006, 06:05 AM
I have the pie chart attached. What I want to do is show a percentage of the whole as I have done. The problem is that some of the percentages are miniscule and are next to one another and the percentage numbers overlap and are hard to read. Is there a way to correct this? Thanks

Andy Pope
10-20-2006, 06:36 AM
Not using a pie chart.

Consider using a bar chart instead. You will need to calculate the % with formula

C1: =B1/SUM($B$1:$B$28)