Solved

how to build this type of chart

Posted on 2014-01-28
2
283 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

624 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