×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# Excel Stack Graph 3

 Forum Search FAQs Links MVPs

## 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

### RE: Excel Stack Graph

Hi,

#### Quote:

I am trying to recreate a graph…

Exactly what 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

(OP)
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.

### RE: Excel Stack Graph

This is a stacked percent chart

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

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

### RE: Excel Stack Graph

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)

### RE: Excel Stack Graph

The data:

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

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

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

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

(OP)
Thank you all.

Super grateful

### RE: Excel Stack Graph

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,

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!

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

#### Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

# Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!