Forum Discussion
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 both columns, go to Insert than Pie chart it doesn't work I guess data has been transposed for that.
Can you please help?
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 🙂
