multiples colores en bar chart

[debcorne]

Buenas Tardes,

Tengo un bar chart apilado con una dimensión con 198 valores posibles, y necesito cada valor que tome la dimesion no se repita.

Alguna Sugerencia?

Gracias

[Gysbert_Wassenaar]

Well, you can start mucking about the the RGB() and or ARGB() functions. Or define a color mapping table in for example excel with rgb values for each dimension value and load that table and use the rgb values that way. But realistically, nobody can distinguish 200 colors shown at the same time like that in a bar chart. A lot of colors will look very similar and practically cannot be distinguished from each other. Try to limit the number of dimension values shown. Perhaps you can group values or create some kind of hierarchy.

[debcorne]

TGysbert,

Entiendo tu consejo, la realidad es que estoy mostrando el top five  de esa dimension y agrupando en otros el resto  en OTROS, El problema que se navega por fechas y se repiten los colores para los distintos dias

e utilizado

Color(FieldIndex('Name',Name)) bitand RGB(245,255,255)

En la definicion de la expresion aun asi se siguen repitiendo los colores

Alguna otra sugerencia?

[johnw]

I don't think you'll be able to find 198 colors that are easily distinguished from each other. But you can certainly define 198 colors that are distinct.

Colors:
LOAD
Dimension
,rgb(R,G,B) as Color
INLINE [
Dimension,R,G,B
A,237,10,63
B,195,33,72
C,253,14,53
... for all your values ...
];

Then use Color as your background color expression.

You might, say, use the list of all Crayola colors, or any other long list of colors.

https://en.wikipedia.org/wiki/List_of_Crayola_crayon_colors#Standard_colors

[Gysbert_Wassenaar]

The problem with the Color() function is that there are only 20 colors. You can either create a color map that associates each dimension value with its own color. Or you need to create an expression that calculates a color using for example the rgb function and the fieldindex number of the dimension value.

[johnw]

marcowedel has script to pull in a large number of colors in this thread:Color by Expression