Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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