😃 Hello Folks!!!
I now want to bring some blogs with excel tips and use of various formulas which will not only make it easier but also make your outputs more quick, efficient, effective and meaningful
Today, lets start with an important tool for all the analysts to present their data in graphical way by adding more meaning and insights for the management - Waterfall Chart or Bridge or Cascade Chart (different names but all are the same)
A waterfall chart can be used for understanding or explaining the gradual transition in the quantitative value of an entity which is subjected to increment or decrement. Often, this chart is used to show changes in revenue or profit between two time periods
Example:
Let's take an example of XYZ Ltd. and show the bridge of Profit & Loss statement (P&L) i.e movement of various items to reach Net Profit starting from Revenues
It will show a graphical representation of the complete P&L showing how much revenue was made during a period by the company and what lead to the final outcome of Net Profit
We will use a simple table and using simple steps in Microsoft Excel 2016 or above, we will create the required chart
Let's begin :-)
Step 1:
Enter numbers in tabular form for which the waterfall/bridge is required
Decreases with Negative Signage; Increases as Positive
Step 2:
Select data and go to insert charts option as shown below
Select the waterfall chart
Step 3:
Select the one which should be from the base (like start point, End point & any other mid point if required)
Double Click to open the format data point; select "Set as Total" option (Revenue, Gross Profit & Net Profit selected in the below example)
Step 4:
Format as required further by changing colors and other options
You can use format chart or Design/Format ribbon on selecting the chart
Step 5:
You are ready with your Waterfall Chart/Bridge :-)
Hope you find it useful...
Happy Excelling 😃
Sachin R Jain (SRJ)
I now want to bring some blogs with excel tips and use of various formulas which will not only make it easier but also make your outputs more quick, efficient, effective and meaningful
Today, lets start with an important tool for all the analysts to present their data in graphical way by adding more meaning and insights for the management - Waterfall Chart or Bridge or Cascade Chart (different names but all are the same)
A waterfall chart can be used for understanding or explaining the gradual transition in the quantitative value of an entity which is subjected to increment or decrement. Often, this chart is used to show changes in revenue or profit between two time periods
Example:
Let's take an example of XYZ Ltd. and show the bridge of Profit & Loss statement (P&L) i.e movement of various items to reach Net Profit starting from Revenues
It will show a graphical representation of the complete P&L showing how much revenue was made during a period by the company and what lead to the final outcome of Net Profit
We will use a simple table and using simple steps in Microsoft Excel 2016 or above, we will create the required chart
Let's begin :-)
Step 1:
Enter numbers in tabular form for which the waterfall/bridge is required
Decreases with Negative Signage; Increases as Positive
Step 2:
Select data and go to insert charts option as shown below
Select the waterfall chart
Step 3:
Select the one which should be from the base (like start point, End point & any other mid point if required)
Double Click to open the format data point; select "Set as Total" option (Revenue, Gross Profit & Net Profit selected in the below example)
Step 4:
Format as required further by changing colors and other options
You can use format chart or Design/Format ribbon on selecting the chart
Step 5:
You are ready with your Waterfall Chart/Bridge :-)
Hope you find it useful...
Happy Excelling 😃
Sachin R Jain (SRJ)
