Stacked Column to track task completion dates with conditions

Thanks Teylyn!

Well, that is beyond me as well. I have attached the data that I am collecting and trying to graph. I am thinking this would be an IF formula, but I dont know how to set it up.

What I would like is a graph that took the managers name and stacked the number of open task and categorized them as less that 15 days, 15-30 days and >30 days. Then next to it I would like a graph that shows closed tasks categorized the same way.

Also, as an aside, I am trying to figure out how to keep the blank cells under Days Open from turning read. I only want cells with data in them to turn colors. Any ideas where I went wrong?

Thanks