Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Yes you can achieve this by set the RGB color for the category and use it ase the base colors.
Regards,
Anand
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
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
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))))))))
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
Hello.
Another option would be to use your If statement to set the expressions background colour.
See the attached example.
John.
Perfect guys
Both solutions work as I wish,
many thanks