Making a "stacked" funnel chart in Excel?

Viewed 9014

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.

This is what I want it to look like - I mocked this up in Paint but I'd like to be able to update it with live data:

SO45421748 Q example

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?

1 Answers
Related