Forum Discussion
Creating pie charts data
Hello, I have created an easy sales and expense sheet for my wife to keep track of her online business and i wanted to add in a Pie chart showing the the percentages of sales on each site. I'm n...
Hi Rock2506,
In order to get the result firstly you need to summarize the data using the COUNTIF function or PivotTable, after that you can select that summarize Go to Insert Ribbon > Charts > Pie Chart
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more