# How to Make Box & Whisker Plots in Excel 2016: A Step-by-Step Guide

Box and whisker plots, also known as box plots, are a nifty way to display data distribution in a simple, easy-to-understand format. They show the minimum, first quartile, median, third quartile, and maximum values in a data set. Excel 2016 makes creating box plots a breeze with just a few clicks. Letâ€™s dive into how you can create your own box and whisker plots in Excel 2016.

## Step by Step Tutorial on How to Make Box & Whisker Plots in Excel 2016

Before we get into the nitty-gritty, itâ€™s important to know that following these steps will help you create a box plot that can be used for various purposes such as identifying outliers, understanding the distribution, and comparing different data sets.

### Step 1: Input your data

When inputting data, ensure itâ€™s clean and well-organized. This will make the rest of the process smoother and your box plot more accurate. Remember, garbage in, garbage out!

### Step 2: Select your data

Click and drag to highlight the data you want to include in your box plot.

Make sure to include all relevant data points, but avoid including any headers or labels in your selection.

### Step 3: Insert a box plot chart

Navigate to the â€˜Insertâ€™ tab, click on â€˜Insert Statistic Chartâ€™, and select â€˜Box and Whiskerâ€™.

Excel will automatically generate a box plot based on the data youâ€™ve selected. You can then customize it to your liking using the chart tools.

After completing these steps, you will have a basic box plot that you can further modify and analyze.

## Tips for Making Box & Whisker Plots in Excel 2016

• Ensure your data doesnâ€™t contain any empty cells or non-numeric data, as this can throw off your box plot.
• Use the â€˜Format Axisâ€™ option to customize your box plotâ€™s axes for improved readability.
• Consider removing outliers if theyâ€™re not relevant to your analysis to get a clearer picture of your dataâ€™s distribution.
• Utilize the â€˜Chart Elementsâ€™ button to add titles and data labels, making your box plot easier to understand at a glance.
• Play around with the â€˜Chart Stylesâ€™ to give your box plot a professional or customized look.

### What is a box and whisker plot?

A box and whisker plot is a graphical representation of data that displays the distribution, median, and variability.

### Can I create a vertical box plot in Excel 2016?

Yes, Excel 2016 allows you to create both horizontal and vertical box plots.

### How do I interpret a box and whisker plot?

The box represents the interquartile range, the line inside the box is the median, and the â€˜whiskersâ€™ represent the minimum and maximum values.

### Can I make a box plot with multiple data sets in Excel 2016?

Absolutely, you can compare different data sets in a single box plot by organizing them into separate columns and selecting them all before creating the chart.

### How do I handle outliers in my box plot?

Excel will automatically mark outliers with dots. You can decide whether to keep them for analysis or exclude them for a cleaner plot.