Pie Chart for Repeated Values

[RyanWi]

Hello,

I have a cloumn with the following values (example)

221
315
565
865
55
323
221
9856
221
589
9744
655
221

As you can see 221 is repeated 4 times so i want the Pie chart to be created for all the values and higher percentage for the repeated value..
Hope it's easy to understand what I wrote.

 

[JustynaMK]

Hi Ryan,

The only solution that comes to my mind is to do the following:

Column A: paste the 13 values from your list
Column B: paste & drag the following formula:
=IF(COUNTIF($A$1:$A$13,A1)=COUNTIF(A1:$A$13,A1),SUMIF($A$1:$A$13,A1,$A$1:$A$13),NA())

As you can see, for the value of 221 the formula displays the sum of all 4 values (884). However, we do not want it to be repeated 4 times, that is why for the remaining 221s the formula displays #N/A.

Now you can create your Pie Chart - treat column B as your values and column A as your labels. If you change the Pie Chart Design to Layout 1, you will see that the value of 221 has a percentage of 4% and is only displayed once.

I hope it helps.