Block Chart set colour based on Demension

[#1]

Hi guys

I have a Block chart based on activity, each activity has a category, for example see below

Activity                               Category

Margin                                Financial

Rate                                   Financial

Cert                                   Documentation

Mail                                   Other

The demensions of the block chart is Activity and Category, but I wish to set the colours based on the categories, so all Financial ( either margin or Rate) will be green , all Documentation blue and so on,

Is this possible ? Can anyone help me please ?

Thanks

A

[its_anandrjs]

Hi,

Yes you can achieve this by set the RGB color for the category and use it ase the base colors.

Regards,

Anand

[its_anandrjs]

Hi,

You need to set some color code in the Colors property of the chart and set base colors try to put this code =if(Category='Financial',Green(),Green()) and see the result.

Regards,

Anand

[its_anandrjs]

Hi,

Put this three codes for color setting in Colors properties.

=if(Category='Financial',Green(),Green())

=if(Category='Documentation',Red(),Red())

=if(Category='Other',Yellow(),Yellow())

For the three categories put this three codes and set Persistent colors check mark.

Regards,

Anand

[#5]

Hi Guys,

I have a code written and I have put it in the demensions tab, Background colour , I have tick persistant colours but it does not seem to work ,

the following is the code - I have tried it on the demensions tab under both demensions - perhaps there is an error - please help

Thanks

=if(Structural='Financial', RGB(0,127,0),

if(Structural='Statics' , RGB (255,128,0),

if(Structural='Arrears' , RGB (255,0,0),

if(Structural= 'Documentation',RGB(255,50,50),

if(Structural= 'General', RGB ( 0,57,01),

if(Structural= 'Mails',RGB(200,127,00),

if(Structural = 'Reports',RGB(255,127,0),

RGB(255,255,255))))))))

[its_anandrjs · Accepted solution]

Hi,

See the attached sample for clearilty i put this three codes for color definition

=if(Category='Financial',Green(),Green())

=if(Category='Documentation',Red(),Red())

=if(Category='Other',Yellow(),Yellow())

for three categories which are available.

Regards,

Anand

[john_duffy]

Hello.

Another option would be to use your If statement to set the expressions background colour.

See the attached example.

John.

[#8]

Perfect guys

Both solutions work as I wish,

many thanks