5 Replies Latest reply: Nov 30, 2009 9:45 PM by Jean-Jacques Jesua

# Color & Bar Chart

Hi,

I have a bar chart with one dimension (cities for example).

I want to assign for each bar a color depending of another dimension (country for example).

Is it possible to do this on the graphic ?

Jean-Jacques

• ###### Color & Bar Chart

Open the small "+" below the expression. Under "Background" you may formulate your conditions, e.g. IF(country = 'France', 'LIGHTBLUE')

Peter

• ###### Re. :Re: Color & Bar Chart

Is There no other method using group dimension ?

JJ

• ###### Re. :Re: Color & Bar Chart

You may group your cities and refer to the grouping: IF(continent = 'EUROPE', BLUE(), IF(continent = 'USA', RED())). You may also load a table with countries and desired colours and refer in the calculation to it.
Or have I understood you wrongly?

Peter

• ###### Re. :Re: Re. :Re: Color & Bar Chart

Thanks Peter, you understood well

I like the idea to create a table but I don't know how to assign color for each DEX (is my dimension) in the background. I tried all...

I created

DEX, COLOR
AJACCIO DPC,red()
BORDEAUX DEX-ELP SUD OUEST,blue()
LYON DEX-ELP CENTRE EST,green()
MARSEILLE DEX-ELP SUD EST,yellow()
PARIS DEX-ELP ILE DE FRANCE,black()
RENNES DEX-ELP OUEST,lightblue( )
VILLENEUVE D ASCQ DEX-ELP NORD EST,cyan()];

• ###### Re. :Re: Re. :Re: Color & Bar Chart

I understood now my problem.

I must apply the backgroung color on the expression and not on the dimension. It works fine now.

JJ