In Excel 2016 Microsoft finally added a Waterfall chart option. It’s a great way to visually show the effect of positive and negative cash flows, on a cumulative basis. 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. Finally, at the bottom of the article, you can download our Excel Waterfall Chart Template.
This has been a free Excel Waterfall Chart Template guide. Check out more of our resources to take your Excel skills to the next level:
List of Excel formulas and functionsExcel Formulas Cheat SheetCFI's Excel formulas cheat sheet will give you all the most important formulas to perform financial analysis and modeling in Excel spreadsheets.
Advanced Excel formulasAdvanced Excel Formulas Must KnowThese advanced Excel formulas are critical to know and will take your financial analysis skills to the next level. Advanced Excel functions you must know. Learn the top 10 Excel formulas every world-class financial analyst uses on a regular basis. These skills will improve your spreadsheet work in any career
Excel shortcutsExcel Shortcuts PC MacExcel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts
All Excel resourcesExcel ResourcesDownload our free Excel Waterfall Chart Template .xls file and follow our instructions to create your own cash flow waterfall chart in Excel. If you’re working in Excel 2013 or earlier versions, please follow the instructions below as a workaround to build your own chart using the stacked column chart feature
Financial Analyst Certification
Become a certified Financial Modeling and Valuation Analyst (FMVA)®FMVA™ CertificationThe Financial Modeling & Valueation Analyst (FMVA)™ accreditation is a global standard for financial analysts that covers finance, accounting, financial modeling, valuation, budgeting, forecasting, presentations, and strategy. by completing CFI’s online financial modeling classes and training program!