Scatter plots in Tableau - Cell-by-Cell Formula Trace

Sample Data

This data shows sales and profit for four products.

Cell	Value
A1	Product
B1	Sales
C1	Profit
A2	A
B2	100
C2	30
A3	B
B3	150
C3	50
A4	C
B4	200
C4	70
A5	D
B5	130
C5	40

Formula Trace

Scatter plot with Sales on X-axis and Profit on Y-axis

Step 1: Select Sales values for X-axis: {100, 150, 200, 130}

Step 2: Select Profit values for Y-axis: {30, 50, 70, 40}

Step 3: Plot points as (Sales, Profit): (100,30), (150,50), (200,70), (130,40)

Cell Reference Map

    A       B       C
1 Product  Sales   Profit
2   A      100      30  <-- Sales and Profit used
3   B      150      50  <-- Sales and Profit used
4   C      200      70  <-- Sales and Profit used
5   D      130      40  <-- Sales and Profit used

Sales (column B) and Profit (column C) values for products are used as X and Y axes.

Result

Scatter Plot:
Y-axis (Profit)
  80 |           * (200,70)
  60 |       * (150,50)
  40 |     * (130,40)
  20 | * (100,30)
     +--------------------
       100  130  150  200  X-axis (Sales)

The scatter plot shows each product as a point with Sales on the horizontal axis and Profit on the vertical axis.

Sheet Trace Quiz - 3 Questions

Which column is used for the X-axis in the scatter plot?

A Product

B Profit

C Sales

D Neither Sales nor Profit

Key Result

Scatter plots map one numeric column to X-axis and another numeric column to Y-axis to show relationships.