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

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

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

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

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

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

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

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

  8. Great Post

  9. Outstanding & easy to follow!

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

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

  12. Awesome article!!!!!

  13. Vey useful

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

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

  16. Great article! Thank you.

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

  18. Thanks, great help

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

  20. thanks.It really helped

  21. Brilliant, thank you.

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

  23. It solves my problem. Thank you.

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

    Thank you for taking time to publish this.

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

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

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

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

    thanks

  29. Hello

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

  31. Ekaterina - thank you for the great tutorial. I really enjoyed creating a waterfall graph to highlight a GM bridge by significant customers. Could not have done this without your Tutorial.

  32. It doesn't seem to work with negative values when the base starts at zero. Anyone else having this issue?

  33. Hi Ekaterina,

    Thanks for your tutorial. Unfortunatelly it does not work for negative values:-(

    David

  34. How can I separately show the Start and End balances from the increase or base numbers? If I enter the balances in the Rise column,they´ll have the same colour as rises in the chart. If I enter them into the base column, they will disappear.
    Thanks for your help!

  35. Hello,
    First of all, thanks for the great tutorial.
    I have following problem:
    the Rise column appears appropriately, beginning always at base level, but the Fall column always begins at zero level. I tried to change the sequence between Base, Fall and Rise but the Fall always is below the 2 others.
    How can I move the Fall chart above Base?
    Thanks for your answer in advance!

    1. I found the mistake: my numbers in the Fall column were negative. :)

  36. Thank you! Very well explained.

  37. Thank you! It is very easy to make waterfall chart with you help.

  38. Thanks for this, had never even heard of this kind of graph until I got asked to produce one. Good, simple instructions.

  39. Great job. This was incredibly helpful!

  40. Thank You!

  41. I found that in summing the 'base' column it was adding all 3 items together rather than minusing the 'fall' figure, I counteracted this by adding a double minus symbol in the equation.

  42. Dear all,
    I have been trying to drawn the waterfall chart as your tutorial but one thing i should ask about the data labelled of negative in fall column, in my spreadsheet it could not have minus sign. How can i fix it?
    Thank you for your fast reply

  43. and what if the base is <0? I think this dos'nt work

  44. Awesome...Thanks for such nice explanation and guidance. It help me a lot.

  45. Excellent tutorial. Thanks for the time taken to prepare and explain. god bless you!!!

  46. I was wondering how you get the blocks to go below the x axis if the data is made up of many negative values. Currently if there are lots of negatives then they just sit on the x axis and don't go below.

    1. To get negative bars below the x axis, you need 2 further datasets. A green one for ascending bars and a red one for descending bars. Then set the number values so bars that cross the x axis are made in 2 pieces: One piece above the x axis and one below. HTH

  47. Its amazing. Wonderfully explained. Going through this step by step even a layman can prepare the Waterfall Chart. Thanks a lot.

  48. This was very helpful! Can you please do one on how to create the same chart but this time with various components that make up the data. For ex. lets say there were 4 different departments that makes up your sales number of 4,000. How do you show the 4 different departments on 1 bar with different colors and what each of their sale numbers were?

  49. Thank you for this. Ridiculous deadline has been met...

  50. Thank you, very straight forward

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