I am trying to create a stack chart based on counts of multiple columns. For example I have a column titled "Quarter" that is a dropdown list which could contain Q1, Q2, Q3, Q4 or Next Year. I have a second column titled "Status" with a dropdown list of Red, Yellow, Green, Blue. Red means not started, Yellow mean Scoping, Green means In Development and Blue means complete.
I want to create a stack chart that shows me in separate bars the total items in each Quarter, then within those bars, I want to know how many of those items are not started, Scoping, In Development of Complete.
I am unable to find any information that could help me do this. Can anyone walk me through this?