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