Creating pie charts data

Occasional Visitor



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 not sure how to do this or what the formula would be across multiple sheets. Example below showing the percentage of sales on Poshmark compared to Ebay or other sites. Any help is appreciated.



1 Reply

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