While I was working on a sales analysis in a retail company, I needed to compare sales performance across different product sub-categories. Along with the sales total, I also wanted to see the sales difference within each category and understand the distribution.
For this, I had to create a chart that could show the spread of values, highlight outliers, and visible comparison of data.
To visualize this data, I created a Box and Whisker Plot in Tableau. In this tutorial, I will explain what a box and whisker plot, or box plot, is in Tableau.
What is a Box and Whisker Plot in Tableau?
In Tableau, a box and whisker plot, also known as a boxplot, is used to display the distribution of a dataset, including its median, quartiles, and outliers.
A box and whisker plot in Tableau summarizes a dataset’s distribution using five key points:
- Minimum: The smallest data point (excluding outliers).
- First Quartile (Q1): The 25th percentile, marking the lower boundary of the middle 50% of data.
- Median: The middle value, representing typical performance.
- Third Quartile (Q3): The 75th percentile, marking the upper boundary of the middle 50% of data.
- Maximum: The largest data point (excluding outliers).
The box represents the interquartile range (IQR), which contains the middle 50% of the data, while the whiskers extend to the minimum and maximum values. Outliers, calculated as points beyond 1.5 * IQR from Q1 or Q3, appear as individual dots.
Check out: Create Area Chart in Tableau
Create a Box and Whisker Plot in Tableau
In this example, we will create a box and whisker plot in Tableau, which will give a summary of Sales for each Sub-Category, divided by Order Month.
For this, connect to the Tableau superstore database and follow the steps below.
- Add the Sub-Category or Category to the Columns and then add Sales to the Rows shelf.
With this, we will get a bar chart displaying the sales of product sub-categories.

- Add the Order Date to the details card in the Marks section. The order date will be in year format, and it will distribute the sales of products for each year.

- To divide and distribute the data further by month, click on the Order Date in the details and select Month. This will show the sales of the products distributed in months.

Check out: Create Radar Chart in Tableau
- Reduce the circle size using the slider size card; this is required to show data points more accurately, otherwise they will appear as overlapped.

- Using the circle data points, we will create the box and whiskers. For this, right-click on the X-axis and select Add Reference line.

- In the reference, select the Box Plot. T