SAP - Advanced Excel Chart

Back to Course

Lesson Description

Lession - #483 Advanced Excel Charts – Water falls Chart

Waterfall chart is one amongst the foremost in style image tools employed in little and enormous businesses, particularly in Finance. water charts ar ideal for showing however you've got came across a web price like lucre, by breaking down the additive impact of positive and negative contributions.

What is a water falls Chart?
A water chart could be a type of information image that helps in understanding the additive impact of consecutive introduced positive or negative values. A typical water chart is employed to indicate however AN initial value is enlarged and decreased by a series of intermediate values, resulting in a final value.

In a water chart, the columns ar color coded in order that you'll be able to quickly tell positive from negative numbers. The initial and also the final value columns begin on the horizontal axis, whereas the intermediate values are floating columns.

Because of this look, water charts are known as Bridge charts, Flying Bricks charts or Cascade charts.

Advantages of water Charts
A waterfall chart has the following advantages– • Analytical purposes: Used particularly for understanding or explaining, the gradual transition within the quantitative value of AN entity, that is subjected to increment or decrement.

• Quantitative analysis: quantitative analysis measure starting from inventory analysis to performance analysis.

• Tracking contracts: starting with the quantity of contracts at hand at the start of the year, taking into account-

o The new contracts that are added
o The contracts that got off
o The contracts that are finished, and
o Finally ending with the quantity of contracts at hand at the end of the year.

• Tracking performance of company over a given number of years.

In general, if you've got AN initial value, and changes (positive and negative>
occur thereto price over a amount of your time, then water chart are often accustomed depict the initial value, positive and negative changes in their order of occurrence and also the final value.

Preparation of data
You need to arrange the data from the given input data, in order that it are often depicted as a water chart.

Consider the following data -
Prepare the data for the waterfall chart as follows -
• Ensure the column net income is to the left of the Months Column (This is because you may not include web cash flow column whereas making the chart>

• Add 2 columns- Increase and decrease for positive and negative money flows severally.

• Add a column Start- the primary column within the chart with the start value within the net income.

• Add a column End- the last column within the chart with the tip value within the web income.

• Add a column Float- that supports the intermediate columns.

• Insert formulas to work out the values within these columns as given in the table below.

In the Float column, insert a row within the starting and at the tip. Place an absolute value 50000. this is often simply to have some area to the left and right sides of the chart.

The data can look as given within the following table-

The data is prepared to make a waterfall chart.

Creating a water Chart
You can produce a water chart customizing Stacked Column chart as follows –
Step 1: choose the cells C2:H18 (i.e. excluding cyber web income column>
Step 2: Insert Stacked Column chart.

Step 3: Right click on the Float series.
Step 4: Click Format information Series within the dropdown list.
Step 5: choose No fill for FILL within the SERIES choices within the Format information Series pane.

Step 6: Right click on the Negative series.
Step 7: choose Fill color as red.

Step 8: Right click on the Positive series.
Step 9: choose Fill color as inexperienced.

Step 10: Right click on the beginning series.
Step 11: choose Fill color as grey. Step 12: Right click on the tip series. Step 13: choose Fill color as grey.
Step 14: Right click on any of the series.
Step 15: choose Gap width as 100% under SERIES choices within the Format information Series pane.
Step 16: provides a name to the chart.

Your waterfall chart is ready.