It’s clear to see that the cost of inventory nearly cut net revenue in half while operating costs accounted for an additional third of net revenue.Ī Waterfall chart provides a simple visual of the running total of your financial data, identifies the contributions and provides clear subtotals, giving you a ready-to-present financial report in a few clicks. The example below shows the income statement for a bookstore. With a Waterfall chart, you can quickly illustrate the line items in your financial data and get a clear picture of how each item is impacting your bottom line. However, quickly understanding and communicating your gains, losses and balances by viewing financial statements can be challenging.
Profit and loss statements can help explain the bottom line of your business. Most business owners seek to better understand their finances in order to ensure their success. Waterfall-visualizing financial statements with ease
#How to add another class to histogram in excel 2016 download#
You can download the sample data used to create these charts here. Read on to see how you can take advantage of these new charts and then try each one out by installing the Office 2016 Preview.
Say hello to Waterfall, Histogram, Pareto, Box & Whisker, Treemap and Sunburst-six powerful charts that help you quickly visualize common financial, statistical and hierarchical data. We added the sample workbook used to create the charts, which you can download here.Īs part of a wave of new updates delivered in the Office 2016 Public Preview last month, we unveiled a set of highly anticipated new charts to give you more ways to explore data and tell rich stories across Excel, Word and PowerPoint.