Forum Discussion

Rock2506's avatar
Rock2506
Copper Contributor
Aug 22, 2020

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

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Aug 23, 2020

    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

Resources