Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
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)