• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

how to build this type of chart

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
billium99
Asked:
billium99
1 Solution
 
Steven HarrisPresidentCommented:
Bridge charts, aka Waterfall Charts.

Jon Peltier has an extended write-up on how to make these.
0
 
billium99Author Commented:
Great! Thanks
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now