2 Replies Latest reply on Apr 21, 2017 5:37 AM by Vicky Castle

    Count and Rank Survey Answers

    Vicky Castle

      I've attached an excel workbook with survey answers where people have ranked items from 1 to 5.  I need to be able to count how many chose 1,2 3, etc for each question so I can show which are the most important in a bar chart if possible like the one below in Excel

       

      Any ideas on how to do this would be greatly appreciated, currently using v9.1