Interactive Waterfall Chart Dashboard in Excel

In 2016, they introduced the Excel waterfall chart. The chart illustrates how the value varies over time, either increasing or decreasing. Positive and negative values are by default color-coded. Unfortunately, Excel 2013 and older versions do not support the waterfall chart type. An Excel waterfall chart sometimes referred to as an Excel bridge chart is a unique kind of column chart used to display how the starting position of a certain data series varies over time, whether it be a growth or decline. The first value is represented by the first column in the waterfall chart, and the last value is represented by the last column. They reflect the total amount in their entirety.

How does a waterfall chart look?

 

How Do I Make an Excel Waterfall Chart?

Example 1: There is a company named “ABC” showing its sales data in the table below. Create a waterfall chart for this.

Answer:

Step 1: Enter all the data in an excel sheet.

Data in an excel sheet

Step 2: Select all the data. Go to the insert tab on the top of the ribbon where then in the charts group select ‘insert waterfall, stock, and other charts’.

finding waterfall chart

Step 3: Click on the waterfall chart.

choosing waterfall chart

Step 4: Now, You will get the waterfall chart with the table.

waterfall chart

How do I change the style of the waterfall chart?

Step 1: You are seeing the two boxes on the right side of the chart.

Looking for a style change 

Step 2: Select the second box, which is placed on the right side of the chart.

Opting style change

Step 3: Choose styles however you want. I have selected style 3, which is depicted in the image below.