Create Excel pie chart from choice placement

Question

I have a table like the following :

                Choice 1      Choice 2      Choice 3  
Person A              3             2             1  
Person B              1             2             3  
Person C              1             3             2  
Person D              1             3             2  

etc.

where each individual has decided, among which one he preferred (number 1), its second best option (number 2) and its least preferred one (number 3).

I know i could generate a pie chart indirectly through the use of scores, but is there a direct way to create a pie chart in Excel to visualize which choice is most favored by the provided placements ?

Answer 1

Here's a quick scaling method that's one step down from scoring, if you really don't want to go that far.

Answer 2

The objective is a pie chart so visually, bigger means better. The scoring was "smaller means better". So the values need to be reversed. Lakovosian's solution does that but the results are not proportional to the scoring. There is a more direct approach that keeps everything proportional.

The scoring was 1 through 3, so the values can be reversed using 4-X. That gives a high score of 3 and a low score of 1. Then just sum up the reversed rankings. It isn't necessary to convert each entry. Basic algebra: if there are N people, the sum of the reversed rankings would be

    4N-SUM(rankings).  

This would give this result:

                    Choice 1      Choice 2      Choice 3  
    Person A              3             2             1  
    Person B              1             2             3  
    Person C              1             3             2  
    Person D              1             3             2  
    Sum                   6            10             8
    Reversed Sum         10             6             8