## Excel Stack Graph

## Excel Stack Graph

(OP)

Hi Team

Hope all is well. I am trying to recreate a graph I saw online> Please see picture https://www.mckinsey.com/~/media/McKinsey/Featured....

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

Hope all is well. I am trying to recreate a graph I saw online> Please see picture https://www.mckinsey.com/~/media/McKinsey/Featured....

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

## RE: Excel Stack Graph

Exactlywhat did you try, in Excel, I assume.Skip,

_{ Just traded in my OLD subtlety... for a NUance!}"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!## RE: Excel Stack Graph

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

To me it looks like a funnel graph.

## RE: Excel Stack Graph

0% Gap

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}"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!## RE: Excel Stack Graph

## RE: Excel Stack Graph

## RE: Excel Stack Graph

Column 1: the stack number

Column 2: =(100 - col3)/2

Column 3: the % value of that stack

Column 4: = col2

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,

_{ Just traded in my OLD subtlety... for a NUance!}"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!## RE: Excel Stack Graph

_{ Just traded in my OLD subtlety... for a NUance!}"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!## RE: Excel Stack Graph

## RE: Excel Stack Graph

combo

## RE: Excel Stack Graph

Super grateful

## RE: Excel Stack Graph

Can you tell us

whatyou found most helpful andwhy?This focused reply will help other members searching for help.

_{ Just traded in my OLD subtlety... for a NUance!}"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!