I have three columns of data, one column is the month in which an item was closed, one column is days it took to close it and one column is the unique id.
I would like to build a histogram with two bins.
The first bin will seperate the count of the date by month, the second will use a traditional bin of 10, 20, 30, 60, 90 etc for the number of days it took to resolve.
Any idea how to do this?

Could I build a Pivot table and "bin" the days it took to close?

Do I need to add a fourth column and calculate the bin, then pivot?

Suggestions welcome and thanks.