Each day, a number of books are returned and tabulated for various reasons—maybe the book is a defect or the customer bought the wrong book.
The Pareto chart allows you to prioritize the improvements you want to make in the bookstore to address the most critical issues. 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.
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.
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. For a bookstore owner, it is important to continuously find new ways to attract customers.
Editor’s Note 7/7/2015: We added the sample workbook used to create the charts, which you can download here.
As 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 Power Point.
The Box & Whisker chart automatically groups the books by their genre and displays the characteristics of the distribution of pricing in a way that can be easily analyzed.
Notice that the book prices of Romance have a wider range and is especially skewed by the one 0 item.
Profit and loss statements can help explain the bottom line of your business.