Excel Stack Graph 3

[laurr]

Hi Team

Hope all is well. I am trying to recreate a graph I saw online> Please see picture

https://www.mckinsey.com/~/media/Mc...Women-in-the-workplace-2018-Ex1-revised.ashx.

It looks like a funnel or a stacked graph but I am unable to re-create. Any ideas on what type of graph it is? And how to re-create it in excel

Thanks for the advice in advance

 

[SkipVought]

Hi,

I am trying to recreate a graph…

Exactly what did you try, in Excel, I assume.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[laurr]

I tried the funnel graph in excel. Flipping it on it's side but I don't know how to fill in the white space with an alternate color in excel

I also tried a stacked graph but I don't know make the bar close together.

To me it looks like a funnel graph.

 

[SkipVought]

This is a stacked percent chart

0% Gap

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[laurr]

You got closer than I did. How did you create it? Can you explain what you did?

 

[strongm]

I'd imagine the key column here is C, with B and D being calculated (well, either B or D being calculated, and then the other having the same value). That's certainly how I'd do it (but I'fd have to then use a stacked column chart, as I don't have access to funnel charts in my version of Excel)

 

[SkipVought]

The data:
[tt]
Column 1: the stack number
Column 2: =(100 - col3)/2
Column 3: the % value of that stack
Column 4: = col2
[/tt]

The chart:
100% Stacked Column
Your column 3 values need to be from 0 to 100, representing percentages.

Once your 100% Stacked Chart is selected, right-click any series in the chart and select Format Series.

In Series Options,
set the Gap Width to 0%.
set the Fill to the color or gradient you desire for each of the three Data Points.


Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[SkipVought]

You can also add Data Point Values to the middle series.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[strongm]

 

[combo]

With gap<100% you can also add lines between categories. As your chart has all necessary data, I would remove x-axis and grid lines (both options can be easily accessed either from layout in chart design tab or selection in format tab). After this:

combo

 

[laurr]

Thank you all.

Super grateful

 

[SkipVought]

So glad you found something that helped you solve your problem.

Can you tell us what you found most helpful and why?

This focused reply will help other members searching for help.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!