A quadrant chart is a scatter plot that is divided into four sections. Quadrant charts can be useful for plotting data that has a high volume of different results. By visually representing the data in separate quadrants, you can quickly find the set of items that share common traits or attributes.
You can create a quadrant chart using Tableau Desktop in one of two ways —by creating scatter plots or defining dynamic quadrants using parameters.
Option 1: Create a scatter plot
Create a matrix of scatter plots. For more information, see Building Scatter Plots in Tableau Desktop Help.
Option 2: Define dynamic quadrants using parameters
Step 1: Set up the view
- In Tableau Desktop, connect to your data. This example uses the Sample - Superstore data source.
- Drag Profit to the Columns shelf.
- Drag Sales to the Rows shelf.
- Drag Ship Mode to Detail on the Marks card.
Step 2: Create parameters
- Right-click (control-click on a Mac) in the Data pane, and then select Create Parameter.
- In the Create Parameter dialog box, do the following, and then click OK:
- Name the parameter. For this example, the parameter is named Profit Parameter.
- For Data Type, select Float.
- For Display format, select Automatic.
- For Allowable values, select All.
- For Current value, enter 95000.
- Right-click the Data pane, and then select Create Parameter.
- In the Create Parameter dialog box, do the following, and then click OK:
- Name the parameter. For this example, the parameter is named Sales Parameter.
- For Data Type, select Float.
- For Current value, enter 700,000.
- For Display format, select Automatic.
- For Allowable values, select All.
Step 3: Add reference lines that position the quadrant lines
- Right-click on the y-axis, and then select Add Reference Line.
- In the Add Reference Line dialog box, do the following, and then click OK:
- For Scope, select Entire Table.
- For Value, select Constant, and then enter 700,000.
- For Label, select None.
- Right-click on the x-axis, and then select Add Reference Line.
- In the Add Reference Line dialog box, do the following, and then click OK:
- For Scope, select Entire Table.
- For Value, select Constant, and then enter 95,000.
- For Label, select None.
Step 4: Create a calculated field that defines a different color for each quadrant
- Select Analysis > Create Calculated Field.
- In the dialog box, do the following and then click OK:
- Name the calculated field. For this example, the calculated field is named Identify Quadrant.
- In the formula area, type a calculation that looks similar to the following:
IF Sum([Sales]) >= [Sales Parameter] AND Sum([Profit]) >= [Profit Parameter] THEN "Upper Right"
ELSEIF Sum([Sales]) >= [Sales Parameter] AND Sum([Profit]) < [Profit Parameter] THEN "Upper Left"
ELSEIF Sum([Sales]) < [Sales Parameter] AND Sum([Profit]) >= [Profit Parameter] THEN "Lower Right"
ELSEIF Sum([Sales]) < [Sales Parameter] AND Sum([Profit]) < [Profit Parameter] THEN "Lower Left"
END
- Drag Identify Quadrant to Color on the Marks card.