![]() ![]() Cash Flow: the amount of cash flow for each period (only enter data in the grey cells the end period should have a formula =SUM(D5:D10) in cell D11).Period: includes a start, end, and all the years/periods to show in the waterfall.In order to build your own waterfall chart, you first have to organize your data as follows: Step 1 – Create a Data Table with 7 Columns To learn more, launch our Excel training courses online. Finally, at the bottom of the article, you can download our Excel Waterfall Chart Template. If you’re working in Excel 2013 or earlier version, please follow the instructions below as a workaround to build your own waterfall chart using the Up/Down Bars and Error Bars features. It’s a great way to visually show the effect of positive and negative cash flows on a cumulative basis. In Excel 2016 Microsoft finally added a Waterfall chart option.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |