CHARTS are the graphic representation of any data . As we know that GOOGLE SHEETS provide us with a variety of charts.
Analysis of data is the process of deriving the inferences by finding out the trends, averages etc. about different parameters.
In this article we are going to discuss about the new WATERFALL CHARTS.
WATERFALL CHARTS are used for a particular situation when we need to see the intermediate values too, before arriving to a final value somewhat like cumulative values.
For Example, This charts starts with the zero and shows the positive as well as negative values shown by the floating columns of different colours, and final column shows the resultant value.
If we try to create a balance sheet using this type of chart, we can derive the net profit as the final value after adding up and deducting the various INs and OUTs of the business.
Let us check the procedure to insert a WATERFALL CHART in GOOGLE SHEETS
The WATERFALL CHART can be inserted through the INSERT MENU > CHART and choosing waterfall chart or by directly choosing the CHART BUTTON on the toolbar and then choosing the waterfall chart.
WATERFALL BUTTON ON TOOLBAR
|PAID SCHOOL FEE||-2000|
The procedure to insert a waterfall chart are as follows:
FOR ALL OTHER TASKS LIKE CHANGING THE NAME OF THE CHART, CHANGING THE AXIS , CHANGING THE CHART STYLE ETC. VISIT HERE [HOW TO CREATE A CHART IN GOOGLE SHEETS].
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE