Color setting on Scatter Plot

mylee

Hi, fellow Domosapiens,

 

I have a scatter plot of many points

 

Is it possible to group them by colours according to countries? (e.g. Australia points are blue, Hong Kong are red, etc)

I have tried the colour setting on the country column and it doesn't seem to work

  

 

RGranada

Hi

 

Is the country the only series in your chart?

 

Regards,

mylee

Hi @RGranada,

 

Thanks for helping!

The series used in the card are the different posts from facebook

Each post belongs to a country

 

Regards,

mylee

RGranada

Ok,

 

So you have multiple series... Each Serie corresponds to posts from a determined country, is that it?

 

Regards,

mylee

@RGranada, yes that is right, the data structure looks like the table below

Currently, it is displaying all points as a different colour, was wondering if we can 'group' the colours, to display all 'Australia' as one colour, all 'Singapore' as another, etc

Post / Series	X-Axis	Y-Axis	Country
A	10	115	Singapore
B	11	116	Malaysia
C	12	117	Australia
D	13	118	New Zealand
E	14	119	Singapore
F	15	120	Singapore
G	16	121	Malaysia
H	17	122	Australia
I	18	123	New Zealand
J	19	124	Singapore

 

...

RGranada

Can you please show me your card setup, just the columns section?

 

Regards.