108monkeys
New Member
- Joined
- Jan 13, 2008
- Messages
- 25
- Office Version
- 2010
How can I create a pivot table for each row to summarise each category to do a count of each unique entry as a pie chart? Here is a sample of what each row and column looks like.
This is a common issue when using forms for each user to categorise their answers using an identical dropdown list for each category but I'm not sure how to create a count of multiple columns to show the summary of the categories selected for each row. Please find attached a chart which demonstrates how each row's category count needs to be represented as a pie chart.
Hope you can assist. Much appreciated.
| A | B | C | D | E | F | G | H | I | J | K | L | M | |
| 1 | Timestamp | Email Address | Name | Date & TIme | City, Country | Question 1 | Category 1 | Question 2 | Category 2 | Question 3 | Category 3 | Question 4 | Category 4 |
| 2 | 4/07/2023 1:05 | xyz@gmail.com | Harry | 12/17/1968 11:06:00 | Melbourne, Australia | Software | Business | Accounting | Financial | Illustration | Creativity | Content | Business |
| 3 | 4/07/2023 1:05 | xyz@gmail.com | Harvey | 10/12/1969 13:25:00 | Melbourne, Australia | iPhone | Business | Computer | Financial | Instruments | Creativity | Content | Financial |
This is a common issue when using forms for each user to categorise their answers using an identical dropdown list for each category but I'm not sure how to create a count of multiple columns to show the summary of the categories selected for each row. Please find attached a chart which demonstrates how each row's category count needs to be represented as a pie chart.
Hope you can assist. Much appreciated.
