How to use and read box and whisker charts in Microsoft Excel

Excel has so many charts that the best one for the job is often easy to miss. You might instinctively reach for the familiar column chart, but that can cause more problems than it solves by obscuring outliers and giving you false averages. For a more honest look at your numbers, it’s time to switch to the box and whisker chart.