Scatter chart dot colors dimension setup not working

[#1]

I have some data that I want to display in scatter chart.
I have 2 dimensions
- dimension1 - this is each record in the table - say unique id for each row. So the number of dots should be equal to number of records.
- dimension1 - this is each record in the table - say unique id for each row. So the number of dots should be equal to number of records.
- dimension2 - this is a combination of 2 columns. tp and vc. Colors of each dot is based on these 2 columns

tp    vc
a      1
b      2
c      1

So there will be dots of 3 colors based on the above tp and vc combinations

Then there are 3 expressions representing X and Y and Size of dot

I am not sure how to configure the dimensions to achieve the goal.

Thanks

[Gysbert_Wassenaar]

Can you post a example with sample data?

[#3]

ID    tp      vc     yi         ye                 q

1     m       v1     10       1.2                10

2     cm     v2      21       2.5                20

3      m      v1      8       1.0                10

4      cm    v2       12      3.5               40

5      mm    v3      14      4.0                 10

So ID represents each dot, tp and vc together represent color, if there are 5 unique combonations then dots will be of 5 colors. ye is X, yi is Y and q is Z

Hope that helps

[Gysbert_Wassenaar]

see attached qvw

[#5]

Thanks for your help Gysbert, I think this works for me, have to test with my data.