Aug 22 2020 02:08 PM
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.
Aug 22 2020 09:20 PM
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