Forum Discussion
Solved
Excel macOs - transpose data for creating a pie chart
I have a simple excel file with two columns. Column A is user email address, column B is Location. I want to make a pie chart that shows the percentage of people for each location If I select...
Create a pivot table based on the data.
Display the number of addresses per location as a percentage of the Grand Total.
Then create a pie chart based on the pivot table.
Demo workbook attached.
Create a pivot table based on the data.
Display the number of addresses per location as a percentage of the Grand Total.
Then create a pie chart based on the pivot table.
Demo workbook attached.
- Dank u wel!
Got it like I wanted 🙂
