I'm trying to graphically represent some data and I'm not sure how to do it or if Excel has the capacity to do it.
There are three centers, and teams from each center apply for an award, and there are several rounds of competition before the award is given out. Each bar represents a round of competition, and the numbers represent how many teams have made it that far. Segmenting the bars shows how many teams from each center have made it to that round.
I can make a funnel with the total numbers, but what I really want to do is make a funnel that divides each bar into sections to represent each center. Any ideas?
