Bernard K

Sep 26, 2020

How to create a quadrant chart in Tableau

Quadrant chart is a scatter plot that is divided into four sections. Useful when plotting data that has high-volume of different results. By visually representing data in separate quadrants, you can easily spot items that share common characteristics and attributes.

A good example of a quadrant chart is in the Gartner’s magic quadrant for analytics and business intelligence platforms report. In this report, vendors are divided into four quadrants: Niche players, visionaries, challengers, and leaders. Enabling users quickly spot providers with same attributes.

How do I create a quadrant chart in Tableau?

To create quadrant chart in Tableau, you will need a scatter plot, parameter, reference line and a calculated field.

In this article, using Superstore data set, we are going to create a quadrant chart using State, Discount and Quantity.

Creating a scatter plot

  • Drag Discount to the columns shelf

  • Drag Quantity to the rows shelf

  • Drag State to the detail shelf

Creating two parameters

These two parameters will be useful when dividing our scatter plot above into four quadrants.

To create a parameter, right click any where on the dimension or measure area >> create >>parameter….

Useful: Learn how to create a parameter in Tableau

Parameter – discount

Parameter – quantity

Add reference lines

To add reference lines, right click on the axis Quantity >> Add Reference Line

  • Under line, select value as ‘Parameter – quantity’

  • Under formatting, chose a continuous bold line

Repeat the same for the axis Discount, as shown below.

Adding the reference lines gives us.

Add a calculated field to color code States on the same quadrant

Create the calculated field below,

Color code the quadrant by dragging the calculated field ‘Quadrant’ to the color shelf or Shape.

I hope this post was somewhat helpful to you. To receive more of the Tableau tips and tricks, kindly join our mailing list by subscribing below.

Thank you for reading.