Pie Chart Help

Occasional Visitor



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!

1 Reply

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