Hello Everyone...
The customer complaints table that working off of has the following information: Complaint ID, Date Opened, Date Closed, Product... etc. I'd like to make a stacked column chart for the last 12 months that shows how many were OPEN each month 0-30days, 31-60days, 61-90days & 90+ days. Now, I can figure out how to write a query that will give me monthly data for one of these criteria, for example 0-30days, but I can't figure out how to combine them or chart them all in the same graph. I've attached a pdf of an excel graph that I currently use. Any help would be greatly appreciated. Thanks!