Solved

how to build this type of chart

Posted on 2014-01-28
2
260 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

773 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