![\"Pic-1\"](\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-1-1.png\")
<\/p>\nMicrosoft Excel has lots of predefined charts to visualize the data like Column, Pie, Line etc. In the new version of Ms-office i.e. 2016 or 365, six new charts have been introduced by Microsoft. In this blog post, we are going to discuss one of them i.e. \u201cWaterfall Chart\u201d.<\/p>\n
What is the Waterfall Chart in Excel?<\/p>\n
A waterfall chart is an advanced type of Excel column chart which is being used to show the positive and negative values based on starting values.<\/p>\n
Let\u2019s see, how waterfall chart looks like-<\/p>\n
<\/p>\n
The first and last column of waterfall chart represents the Total value. The intermediate columns show Positive and negative values in a float. These columns are colour coded for distinguishing positive and negative values.<\/p>\n
A waterfall chart is also known as \u201cExcel Bridge Column Chart\u201d, as we can see floating of the columns makes a so-called bridge.<\/p>\n
Note: In the Previous Version of Ms-office like 2007, 2010 and 2013, we used to create waterfall chart manually, However, In the latest versions of Ms-office 2016 or Ms-Office 365 this is a given chart type.<\/em><\/p>\n <\/p>\n How to create a waterfall chart in Excel 2016 or Office 365?<\/p>\n The sample data above has a monthly cash flow statement for the FY 2017-18. Let\u2019s understand how one can convert our data into \u201cWaterfall chart\u201d. Follow the steps-<\/p>\n As we can see on the vertical axis, the base value starts from point 0. First month\u2019s value is Negative 500, So, It started with less than zero points and for the next columns it is floating in between the positive and negative values. Isn\u2019t Cool \ud83d\ude0a<\/p>\n <\/p>\n Formatting of Charts<\/u><\/strong>–<\/p>\n <\/p>\n Chart Title-<\/strong> By default, this option will reflect on the top of the chart, however, if it is not there then follow the steps\u2013<\/p>\n Click on chart Title and write the title Name \u201cCash Flow Statement FY 2017-18\u201d<\/em><\/p>\n Data Labels \u2013<\/strong> we can highlight the value of the column inside end or Base on the columns, Centre or Outside end.<\/p>\n Customising column colores<\/strong>– Let\u2019s show first and last column in a different colour and the different colours for positive and negative values.<\/p>\n Hope you enjoyed this post. If you have any query or suggestions, kindly leave your comment below.<\/p>\n <\/p>\n Happy Learning \ud83d\ude0a<\/p>\n![\"Pic-2\"](\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-2-1.jpg\")
<\/p>\n\n
![\"Pic-3\"](\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-3-2.jpg\")
<\/p>\n\n
![\"Pic-4\"](\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-4-2.jpg\")
<\/p>\n\n
![\"Pic-5\"](\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-5.jpg\")
<\/p>\n![\"Pic-6\"](\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-6-1.jpg\")
<\/p>\n\n
![\"Pic-7\"](\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/11\/Pic-7-2.jpg\")
<\/p>\n\n
<\/div>\n