![]() ![]() We are going to hide the base series and customize the colors of the increasing and decreasing values.Ĭlick on any of the bars and select the Chart Format option Ribbon. Once the data has been prepared, we need to tweak the series bars. Step 4 – Editing the chart series to represent the waterfall The following image shows all the formulas applied to the data. The Start and End Column contain the initial and final values of the flows respectively. An IF statement or a Max function can be computed. The Positive Column contains the positive values of the flow. It can be computed with an IF statement.or a Min function: The Negative column will contain the negative values of the flow. The Cummulative column is the addition of the flows.ī4 = G3 + G4. In order to populate the new columns some formulas need to be used. Note that the only manually populated columns are the Series column and the Net Cash Flow columns. This are the values that should be shown in the PowerPoint Waterfall Chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |