Scatter plot with two nominal variables

Hi xzhang32,

First, ensure when connecting/importing your data that each column has the correct data type.

• Experiment ID = Whole number (remove the C from the beginning if possible - scatter plots don't like non-numerical values)
• Sample ID = Whole number
• Result = Decimal number

After adding Experiment ID as the x-axis set this attribute to "Don't summarize"

Do the same operation for the y-axis with Sample ID: Don't summarize

Add the Result column in the "Color saturation" shelf and then you can define a divering colors in the visual options to represent the Result

After applying these steps the data points in the scatter plot won't be summarized (Sum, count, etc.) and this should help you achieve your intended visual.

Sample data:

Visual:

Let me know if this is helpful or if you have any questions.

Thanks

Kevin