Group Date Column in PivotChart

[BrandonNC]

Hi All. I've got a Table on a sheet that tracks a list of upcoming (and sometimes past) dates. I'm trying to create a pie/donut chart that shows how many of those dates are either Past (red slice), Upcoming within 30 days (orange slice), Upcoming within 90 days (blue slice), or all of the rest that are beyond 90 days from now (green slice).

I've tried doing this with a regular chart and a PivotChart and the closest I've come is a PivotChart that has slices grouped by the count of each date (since I only have a few different unique dates). I've also tried Calculated Fields on the PivotChart, all to no avail. This is surely because I'm just too new and unfamiliar with Excel charts to know how to do what I want.

Any guides or tips would be greatly appreciated!

Thanks!