Forum Discussion

tjmccart's avatar
tjmccart
Copper Contributor
Sep 25, 2022

Pie Chart Help

Hello,

 

I'm trying to track the percentage of how many times a specific number was entered in a column and turn that into a Pie Chart and I'm struggling to figure that out. Is that even possible? Does anybody have any ideas? Thanks in advance!

Charting
excel

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Sep 25, 2022

    tjmccart Two very basic example in the attached file demonstrate what's possible. One uses the UNIQUE and COUNTIF functions to form the basis for the pie chart. The other uses pivot table and a pivot chart.

    See if either of these works for you. If not, please come back and show how your data really looks like. Share a file via OneDrive or similar and stat the Excel version you are working with.

Resources