Comments on: How to create waterfall chart in Excel (bridge chart)

This article looks at creating basic graphs and at a special chart type – the Waterfall chart in Excel. Read on to find out what a waterfall chart is and when you can find it useful. You'll learn what tools can help you with creating waterfall charts in Excel 2016, 2013. Continue reading →

Comments page 4. Total comments: 161

  1. very helpful, thanks

  2. It worked well for me.Thanks a ton!

  3. Hi All,

    I want Create Hours Base Graph. can you tell me how can create this.

    Question Example:- 10:00 Am 01:00 PM Total Hours ? Graph Chart?

  4. Very good and easy explanation , Thank you.

  5. Hello , thank you for this helpful demonstration it has taught me alot . My chart is populated and looks exactly as yours does other than the series fall on my chart is showing as 0s instead of the minus numbers . how can i change this without having to enter all of the figures manually please? Many Thanks Amy

  6. Thank you So much this was the most easiest explanation i found on creating waterfall graphs.

  7. Great tutorial

  8. Is there a way to break the Bar chart in waterfall bar chart. One of the value in my data set is quite big and everything else looks very small. So I would like to break the Y axis and the big bar so that all bars are properly visible.

  9. This is great thank you so much!! I had a question. If I wanted to split the fall or rise into three stacked groups as opposed to one how would I do that? For example, January would have Group A=+1500, Group B=+1500, Group C=+500 = 4000 all in one bar.

    Thanks again! :)
    -Chris

  10. Still getting confused with the last bar, the "end" column, cannot select and format on its own, can only select the entire series of "hidden" bars that are hidden/underneath the incremental changes, i.e. the rise/fall bars. Using Excel 2007 (no, cannot upgrade)

  11. I love you, you saved my day at office.

  12. Very NICE!!! Thank you!!

  13. Thank you - very helpful and user friendly.

  14. How about in S.A

    1. But thanks ,well done

  15. Thank you for the simple, yet effective explanations and illustrations.

  16. Very Well explained..I developed PowerPoint/Excel plugin for creating Waterfall chart just like that..Contact me at abhinovpankaj1@gmail.com for more details.

  17. thanks for the information

  18. Thanks for this easily understood tutorial. I have one question which I think still has not been resolved. How did you manage to remove the "base legend" without removing the invisible bar chart? When I try to remove my similar bar chart it makes the floating bars fall to the ground...

  19. When you have several consecutive negative values forcing the base to become negative the falls do not appear below the x axis and show as positive values. Is there a fix for this please?

  20. Thank you so much for publishing this!! Awesome detailed instruction for something a little bit intricate!! Really needed to do some of these charts - deadline today and never did them before. Thanks again!

  21. Hello Thank you for your note.just getting confuse with end data how to populate that in graph.

  22. Excellent, crystal clear explanation! Thank you so much.

  23. Thanks alot....very nicely explained a complex chart....awsome....cherss...... :)

  24. Thank you so much for sharing, this really helped. God bless!

  25. Very very very useful. Takes minimum time to understand and execute
    Thank you

  26. Yes, very helpful guide. Can anyone advise on how to include connector lines between the monthly values
    (------) Thanks.

  27. Dear Ekaterina, thank you for sharing this. I agree will all positive comments.

  28. Great Post

  29. Outstanding & easy to follow!

  30. Dear Ekaterina Bespalaya - Thanks for sharing this tutorial; so easy for even excel dummies to follow. Enjoy your vacation to the Max.

  31. So, to fix the "zero display" issue, you can create another column to chart (or enhance what's there - up to you), with an "IF" statement that replaces zero values with "NA()" (without the quotes).
    So, if the original calculation is in "I3", a formula in another column (to be charted) with this formula results in "#N/A" showing in the cell, ant that will not get charted:
    =IF(I3=0,NA(),I3)

    Also, if my chart had the dates in the first column on the zero axis, but there were was nothing below zero; so to make the dates as labels at the bottom, click on the Y-axis, Format axis, Axis options, and make the Minimum "Fixed" and = 0.

    As others have said, a downloadable version of the spreadsheet would be helpful, especially if it incorporated some of the comments above. (Otherwise, that was / is a really long vacation :) ).

  32. Awesome article!!!!!

  33. Vey useful

  34. Thanks for the tutorial, very easy to follow (for us excel dummies!)

  35. How can I get rid of the start column completely, I do not want it to show up in my chart, but great chart, it's really simplified waterfall charts for me :-)

  36. Great article! Thank you.

  37. What an excellent article on Waterfall chart, perfectly articulated and demonstrated, this is impressive work.

  38. Thanks, great help

  39. Much appreciated. Your article has made it so simple to understand the waterfall graphs

  40. thanks.It really helped

  41. Brilliant, thank you.

  42. Thank you very much , the way it is explain its fantastic

  43. It solves my problem. Thank you.

  44. What an excellent article, perfectly articulated and demonstrated, this is impressive work.

    Thank you for taking time to publish this.

  45. how can a water fall chart be created using all positive values

  46. dude can you please send all chart making step...

  47. hi,

    its really useful every one and I want all chart how to make it easily I need some more explanation other its good work thanks to all and am working fully excel and PowerPoint I want to know some technical steps that's useful to my work thanks that's all thanks to all dude.

  48. Dear Jeo
    can you please send us link of video.

    thanks

  49. Hello

  50. I have a waterfall chart but in the first column only the fill the start and end is filled with a line a dark line on top any idea how is done
    Any idea?

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)