Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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  


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 ?

share|improve this question
Can you please help clarify what exactly you're looking to visualize? Do you want a single chart that has all 12 values? Or 3 charts, one per choice? Or 4 charts, one per person? Also, pie charts specifically show parts of a whole (percentages), so you'll likely need to convert your ranking to a percentage to have the chart show properly. Perhaps another chart type (maybe column/bar) would be more appropriate? –  dav May 31 '12 at 11:28
Tough question : i am not fixed on a number of charts. The idea is to be able to generate an opinion as to which choice is most favored by voters. Any idea where i don't have to ponderate 1st choice with 2nd choice is welcome. –  Benoît Jun 1 '12 at 7:30

1 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.

Quick scaling method.

share|improve this answer
Interesting idea. I have to think about it. –  Benoît Jun 1 '12 at 7:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.