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 2. Total comments: 161

  1. SUCCESS!!!
    This is fantastic. Thank you for sharing

  2. This information was very helpful, I surprised myself and was able to create one.

  3. My waterfall chart does not drop below the 0 line, how can I change this?

    1. +1!!

      Doesn't work if you go negative...as the 'fall' is always a positive number.

      1. It is fantastic and easy to follow. Got problem with negative and don't go below zero

  4. I am very happy with my waterfall chart - it looks fantastic and the instructions were easy to follow. There may be other ways to do this (mentioned in other comments, not sure why they are searching if they already know how to do it) however this was simple and easy to follow.
    Thanks for sharing.

  5. Hi,

    Thank you for the explanation. I have also seen that in other waterfalls that there are lines that connect the up and down bars. If you have time can you show me how that is done? Thank you.

  6. This did not work as explained. I followed the steps, and inputed the same values above and my start value included rise value and Sales flow values stacked on top eachother. In addition, the negative values on the graph are below the Horizontal axis, (off chart)

  7. Nice chart, Just wanted to know whether we can have dynamic waterfall charts with slicers?

  8. Awesome - thank you, much more helpful than excel help!

  9. FYI - Office Professional 2016 now has a waterfall chart type. The template works with a click of a button, without even having to put together the base and other stack data. Nice and easy. I'd assume Office 2016 (non-profession) would have had this too?

  10. This is GREAT! My 1st WaterFall Chart ever!!! Thanks!!!

  11. WOW ! This is such great explanations. Do you have other kids of charts I could be tought of !
    Very clear.
    Merci ;)

  12. Thanks , It was very useful .

  13. I agree with other comments, I cannot understand how you get negative values to show as data label?

  14. How can you amend to show negative bars dropping beneath the origin line? Where a balance is negative, the downward blocks won't show below zero.

    1. Usually in the series options under fill you can check the box marked invert if negative

  15. Wow Great imaging helpful for sales presentation .

  16. Hi,

    good info, but how you are showing negative data labels in the final step when the actual value in the original table is zero?

  17. Hi, Thank you for nice explanations. I have doubt, The End data you did not discuss anywhere, how does it appear on the chart? Thanks.

  18. Many thanks, looks great.

  19. fyi

  20. Thanks! Worked perfectly

  21. Works like a charm. Thanks

  22. Thank you for taking out time to explain the tutorials. It is excellent and easy to use. Thanks.

  23. Brilliant and very helpful step-by-step tutorial. Many thanks.

  24. Thanks!!

  25. Thank you very much. Great explanation. Just what I needed.

  26. This is awesome!! It really sorted me out. Thank you.

  27. Oh my god this was amazing!!! Thank you so much!

  28. Thanks for sharing!

  29. I use MarketXLS for this and it's great.

  30. Thank you first of all for this great tutorial and simple to use instructions. When I tried to create my WF chart, after I started with all positive values, and then when the negative values started and the first negative data set "added" to the total of the positive values - that is the stacked column actually went higher rather than dropping - the rest of the negative values after that - it dropped and the final ending number was proper to scale - but the first negative value - the column actually went up instead of dropping - Not sure what I am doing wrong? Please help if you are able to.

  31. Need a solution for water falls that go negative!

  32. This is a great and simple solution. Many thanks.
    But I always use bridges in situations where I have to show 'negative' going into 'positive' ie, EBITDA improvement.
    The current solution will not work for negative to positive positions, I think. Do you have any tutorial that would address this case?
    Best

  33. if my start value is Zero, how to do the waterfall? thanks

  34. Not to nit-pick, but "=IF(E4<=0, -E4,0)" is the same thing as "=-MIN(0,E4)" and the latter is easier to understand. I see people use IF statements for this all the time, but learning MIN and MAX make writing out and auditing the formulas a lot easier. Just FYI.

    Also, it looks like Excel 2016 finally has built-in waterfall chart support. I haven't tried yet so if someone has, please post your experience with it. I hate manually doing this (rather, I hate executives that require these).

  35. Great explanation. It would be useful to know how to deal with negative figures as the above method doesn't seem to work for them.

  36. Very usefull. Congrats

  37. Thank you for a clear and concise explanation.

  38. Genius. thank you. it works perfectly.

  39. Hi,

    Need to create a waterfall chart with price growth & volume growth data.

    Can u plz guide?

    Arun

  40. Thanks much for wonderful tutorial. Nobody could teach the technique in such an easy to understand manner.

    Will go through all other tutorials.

    Thanks a lot , you are doing an awesome work.

  41. very helpful, thanks

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

  43. 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?

  44. Very good and easy explanation , Thank you.

  45. 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

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

  47. Great tutorial

  48. 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.

  49. 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

  50. 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)

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 :)