Excel New Chart Types

There are new chart types in Excel 2016, including Waterfall, Sunburst, Tree map, Funnel, Histogram, Pareto, and Box and Whisker. They can be used from programs like, Excel, Outlook, PowerPoint, and Word. Here are a few details:

• Waterfall - A 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.
• Histogram - Commonly used in statistics, a histogram automatically displays the frequencies within a distribution. In this example, the horizontal axis represents the book price. Each column, called a “bin,” shows the number of books within a given price range. Here we see that this bookstore has a good distribution of books, both high-end and low-end.
• Pareto - Using the Pareto chart, you can automatically sort the frequency of the most prevalent issues (the bar graph) and then show the additive contributions of each issue as you move along the horizontal axis (the line graph). The Pareto chart allows you to prioritize the improvements you want to make in the bookstore to address the most critical issues.
• Box & Whisker—bringing statistics to distribution. Like the Histogram chart, the Box & Whisker chart shows the distribution of information. For deeper analysis, this chart goes further by providing key insights about the distribution in one view, including range, quartiles, mean and outliers. And you get all of this information with a few clicks.