Solved

how to build this type of chart

Posted on 2014-01-28
2
251 Views
Last Modified: 2014-01-28
Hi,

These charts like the jpg I have attached have become really popular lately. The far left bar is current state and the far right bar is ideal or future state, and the bars in between don't rest on the Y axis, but instead start from the top of the current state value and work down describing incremental values affecting the final outcome.

In my attached  example I made in paint (!) let's say we start with 1000 widgets, which is bad, and we have three initiatives that we think will subtract from our widgets to get us to a more manageable amount at the end.

How can this type of chart be built in Excel and what is it called?

Thank you

Bill
sample-chart.jpg
0
Comment
Question by:billium99
2 Comments
 
LVL 18

Accepted Solution

by:
Steven Harris earned 500 total points
ID: 39815705
Bridge charts, aka Waterfall Charts.

Jon Peltier has an extended write-up on how to make these.
0
 
LVL 1

Author Closing Comment

by:billium99
ID: 39816145
Great! Thanks
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
I need to access elements from an existing child window to extrat info! 19 45
ms office troubleshooting for users 8 36
Boolean help 6 29
Excel - find text within text? 1 25
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now