Scatter Chart (Text to Number)

[#1]

Hi all,

I have the following issue and would be very thankful if someone could help me with this:

I have two set of data

Category A:

1

2

3

4

Category B:

low

mid

high

I want to show this data in a scatter chart, where the X-Axis shows Category A from 1 to 4 and Y-Axis shows Category B from low to high..

So if for one data set Category A is 2 and Category B is "mid", I'd like to get a dot in the matrix (x=2,y=2)..

I guess the problem is that Category B is text and not numbers.. so which expression do I have to use?

For Category A i used : only([Category A]), this however does not work for Category B...

Thank you for any help!

[#2 · Accepted solution]

I solved it with the help of a LOAD*Inline:

Load*Inline [

Category B, Category_B_number

low,1

mid,2

high,3

];

And then I used Category_B_number in the expression of the chart.

[kji]

Sounds like what you really want is a grid chart (x-y plot with discrete axis values) and not scatter chart (x-y plot with continous numeric values)