How to Create a Box Plot in Tableau

Creating a box plot in Tableau is one of the best ways to quickly understand the distribution of your data and spot outliers at a glance. But getting it to look and work the way you want can feel a little tricky if you’re new to the tool. This guide will walk you through the entire process, from understanding what a box plot shows to building and customizing one from scratch in Tableau.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is a Box Plot, Anyway?

Before we jump into the “how,” let’s quickly cover the “what.” A box plot, also known as a box-and-whisker plot, is a chart that shows the distribution of a dataset based on a five-number summary. It’s perfect for comparing the distribution of a numeric value across different categories.

Think of comparing sales performance across different product categories, test scores across classrooms, or shipping times across different regions. A box plot makes it incredibly easy to see where the bulk of the data lies and which points are unusual.

The Anatomy of a Box Plot

Every box plot is made up of a few key components that represent your data's spread:

• Median (Q2): This is the middle value of your data. The line inside the box represents the median. Exactly 50% of your data points are above this value, and 50% are below.
• The Box (Interquartile Range - IQR): The box itself represents the middle 50% of your data.
• The Whiskers: The lines extending from the top and bottom of the box are called whiskers. By default in Tableau, they typically extend to 1.5 times the IQR from the top and bottom of the box. They show the expected range of your data.
• Outliers: Any data points that fall outside of the whiskers are considered outliers. These are individual points plotted on the chart and are often worth investigating. They might represent errors in the data or genuinely unusual events.

Preparing Your Data for a Box Plot

The good news is that box plots don't require overly complex data structures. To build a box plot in Tableau, you generally need two things:

1. A measure (a numeric value) that you want to analyze. This could be anything like Sales, Profit, Age, Page Load Time, or Order Quantity.
2. One or more dimensions (categorical values) that you want to use for comparison. Examples include Product Category, Region, Marketing Channel, or Customer Segment.

For our example, we'll use Tableau's sample "Superstore" dataset. We'll build a box plot to analyze the distribution of Sales for each Sub-Category of products.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Guide to Creating a Box Plot in Tableau

Let's get down to the practical steps of building the chart. If you have the Superstore dataset open, you can follow along directly.

Step 1: Place Your Dimension and an Initial Measure

First, we need to set up the basic structure of the chart.

• Drag your primary dimension, Sub-Category, from the Data pane onto the Columns shelf.
• Drag your measure, Sales, from the Data pane onto the Rows shelf.

At this point, you'll have a simple bar chart showing the sum of sales for each sub-category. This isn't what we want yet, but it's a necessary starting point.

Step 2: Disaggregate Your Data Points

A box plot needs to visualize the distribution of all individual data points, not just an aggregate like SUM() or AVG(). To do this, we need to show every single mark (or sale, in this case).

• Go to the Analysis menu at the top of the Tableau window.
• Uncheck Aggregate Measures.

Your view will now change dramatically. Instead of a bar chart, you will see a vertical strip of points for each sub-category. Each point represents an individual sale. It might look messy, but this raw distribution is exactly what Tableau needs to build the box plot.

Step 3: Change the Mark Type to a Box Plot

Now we just need to tell Tableau how to display all of those points.

• Navigate to the Marks card on the left side of the screen.
• Click the dropdown menu (it probably says "Automatic" or "Circle").
• Select Box-and-Whisker Plot from the list.

Voilà! Tableau instantly converts the individual marks into a series of box plots, one for each sub-category. You have now successfully created a basic box plot.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Alternative Method: Using the "Show Me" Panel

Tableau often provides multiple ways to do something, and box plots are no exception. The "Show Me" panel is a great shortcut.

• Hold down Ctrl (or Cmd on Mac) and click to select both your dimension (Sub-Category) and your measure (Sales) in the Data pane.
• On the top right of the application window, click the Show Me button to expand the chart options.
• Select the box-and-whisker plot option (it’s usually in the second row).

Tableau will automatically perform the necessary steps, including disaggregating the measures and arranging the pills on the shelves, to build out the box plot for you.

Customizing and Refining Your Box Plot

The standard box plot is great, but a few tweaks can make it much more insightful and visually appealing.

Editing Look and Feel

In the Measures card, you can click on Color to change the color of the boxes and whiskers. You can also drag another dimension, like Region, onto the Color mark to create separate, color-coded box plots for each region within each sub-category.

You can also format the borders and lines by right-clicking on the plot and selecting Format. This opens up options to adjust axis lines, grid lines, and more.

Editing the Whisker Range

By default, Tableau's whiskers extend out to 1.5 times the IQR. However, you can change this.

• Right-click on the vertical axis (the Sales axis in our example) and select Edit Reference Line, Band, or Box.
• In the menu that appears under "Box Plot," you'll see a section called Plot Options.
• Here, you can change the Whiskers extend to: option. You can choose "Maximum extent of the data" to have the whiskers go all the way to the minimum and maximum values in your dataset (this will hide the outliers).

Hiding Underlying Marks

The little circles behind the box plots are the individual data points (outliers). Sometimes, showing them can make the chart feel cluttered. To hide them:

• Again, go to Edit Reference Line, Band, or Box.
• Under Plot Options, uncheck the box for Hide underlying marks (except outliers). You can play with this setting to see what works best for your visualization.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Read and Interpret Your Tableau Box Plot

You've built and styled your chart. Now, how do you pull insights from it? Let's use our "Sales by Sub-Category" plot as an example.

• Comparing Medians: By hovering over each plot's median line, you can quickly compare central performance. For instance, the median sale for "Copiers" is likely much higher than the median sale for "Paper." This shows a typical transaction for copiers is larger.
• Assessing Consistency (The Box Height): Look at the size of the boxes. A very tall box, like for "Tables," suggests that sales figures are highly variable. A short box, as you might see for "Fasteners," indicates that most sales fall within a very narrow, consistent price range.
• Identifying Outliers: The most significant outliers immediately draw your eye. In the Superstore dataset, you’ll probably see several extremely high sales in the "Copiers" and "Machines" sub-categories. These individual outliers might represent large corporate orders and could be instances you'd want to analyze further. Were they from a specific sales rep? A particular region? You can use them to drive deeper questions.
• For easier reading, you can sort the sub-categories based on their median Sales. Right-click on the "Sub-Category" pill on the Columns shelf, select Sort, and then sort by Field (using Sales and an aggregation of Median).

Putting it all together, our quick glance at the Tableau box plot instantly tells us that while categories like Binders and Paper have many sales, they're all low-value and very consistent. In contrast, categories like Copiers and Machines have fewer but much higher-value sales, with a lot of variance and several significant outlier sales.

Final Thoughts

Creating a box plot in Tableau is an incredibly powerful way to get a quick, accurate view of your data's distribution. By understanding the components of the chart and mastering the creation process, you can easily compare categories and uncover critical insights that might get lost in a simple bar or line chart.

While mastering tools like Tableau is a valuable skill, we know the learning curve can be steep and time-consuming. Sometimes, you just need clear answers about your data without wrestling with shelves, marks, and settings. At Graphed, we handle the technical work for you. You can connect your marketing and sales data sources in seconds and then simply ask in plain English - "create a box plot comparing campaign spend vs ROI" or "show me my sales pipeline distribution" - and we'll instantly generate the live dashboard, giving you back hours to focus on strategy, not chart-building.