Table of content

Boxplot chart in Tableau

The box plots are also known as box-and-whisker plots. These box plots show the distribution of values along with an axis.

Boxes indicate the middle 50 percent of the data which is, the middle two quartiles of the data's distribution.

The remaining 50 percent of data on both sides are represented by lines also called whiskers, to display all points within 1.5 times the interquartile range, which is all points within 1.5 times the width of the adjoining box, or all points at the maximum extent of the data.

The Box Plots take one or more measures with zero or more dimensions.

Creating a Box Plot:

  • Open Tableau and click on Connect to Data.
    connect-to-data-tableau
  • Then the Connect page will open, click on Microsoft Excel.
    click-on-connect-to-data-excel-file-tableau
  • Navigate to the downloaded files, select Sample Superstore.xls excel file, which is a saved excel file, and clicks on Open.
    connect-sample-superstore-to-tableau
  • You can download a Sample Superstore.xls file from the link: https://chercher.tech/files/
  • Once the data source has been connected, open a new worksheet by clicking on sheet1.
    naviagte-to-sheet1-tableau
  • The Sample Superstore excel file contains the below details.
    sample-superstore-excel-file-tableau
  • Here, we are going to find the size of profits for the respective category for each Ship mode value.
  • To achieve this, follow the steps in the Tableau worksheet:
    • Drag and drop the dimension variable Category to the column shelf and Profit to the Row shelf.
    • Also, drag one more dimension variable Ship-mode to the column shelf.
    • Select Box-and-Whisker plot from Show Me.
    • The following chart appears which shows the box plots. Here, Tableau automatically reassigns the ship mode to the Marks card.
      box-and-wishker-plots-tableau
    • You can also create a box plot with two dimension values, drag and drop Region dimension value to the column shelf, this will produce a chart that shows the box plots for each region.
      box-plot-with-region-dimension-tableau
0 results
Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions