2 posts / 0 new
Last post
Groups and colours

I have tried and tried to figure out how to have different coloured groups.
Can you take me through a simple way just for stat trends plus. I find the
pdf manual hard to convert away from the maps. Thanks in advance.

StatSilk's picture

Hi Pete,
Do you mean the colors for the scatter plot? In the sheet 'Groups' you can create custom groups with your variables (the ones in the top row of the sheet 'data'). So you define a group name in col A, a color in col E (2nd column as the other columns are hidden), and your variable names from col G onwards. The color needs to be in HEX format, for example the format 0xFFFFFF (see also https://www.google.com.au/search?q=hex+color&oq=hex+color). I hope that helps.

To color also the bar charts using group colors, you would need to set the variable 'GR-C-CLR' in the sheet 'settings' to TRUE.