How to make scatterChart based on 2D text data?

[abcip]

I want to create a scatterChart consisting of category 1(column 1) on the X-axis, category 2(column 2) on the Y-axis, and the number of data corresponding to each bubble size. (The column3 is the unique number for each row)

Each category contains data in text format. (Ex, category 1 includes c1_text1~3 and category 2 includes c2_text1~4)

I think you should put the data of column 1 on the X-axis, put the data of column 2 on the Y-axis, and put the count of column 3 on the size.

However, the data of column 2 is not moved to the Y-axis item.

Even if I select as above, the data field does not move.

The data type of all columns is text.

If you enter data into the items as shown in the figure above, the following error is displayed.

For example, I want to express the number of data corresponding to text 1 in category 1 and text 2 in category 2 as bubble size.

[amitchandak]

@abcip , we can not use two text column on standard scatter visual

you can try

Charticulator Part 2 - Scatter with Shapes: https://www.youtube.com/watch?v=QIPsv5hNbqI

Charticulator Part 1 - Bar and Bar Matrix: https://youtu.be/tKgG0arMaOw