I would like to create a chart that shows the man hours by month based on a Deal.  The idea is on each Deal there would be Start Date, End Date, and Avg Man Hours by Month.  Then we could create a chart that summarizes all the Deals, totals the Avg Man Hours by month, and the x-axis would be the next 12 months.

I have tried multiple things

-  Created custom fields specific to each month (i.e. - July 2021, etc..) and saving the Avg Man Hours there but then I can't Summarize more than 5 fields so that doesn't work.

- I also don't think the reports are smart enough to know whether a Date is Between a value so I can't use a report either.

I need some help please.