Creating pie charts data

Highlighted
Occasional Visitor

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 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.

 

spreadsheet.jpg

1 Reply
Highlighted

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

 

Snag_f2b11cb.png

 

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