×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • 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.

Students Click Here

Excel Stack Graph
3

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

RE: Excel Stack Graph

Hi,

Quote:

I am trying to recreate a graph…

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

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"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

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

RE: Excel Stack Graph

(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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"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.

Reply To This Thread

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:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close