Re:Load colour

[Chanty4u]

Hi all,

i have doubt on setting colour codes to the charts in a dashboard.

As  i hve loaded the  colors.xls  file into qvw .

My req is:

i have one barchart so the bar colours shud be display as per  order arragned in colours tab:

but  i need to set the default colours into my application  and  when ever i use the chart   that colours only applied to that bars?

how can i do this?

Thanks in advance.

Suresh

[tresesco]

You could use calculated color for individual bars. Expression would be like:

=$(=FieldValue('ColorCode',1))

=$(=FieldValue('ColorCode',2))

=$(=FieldValue('ColorCode',3))

...

PFA

[tresesco]

Otherwise, you might associate the color code field with your dimension field and use that for background color.

Edit: sample attached

[Chanty4u]

thnx for response Tresesco.

As u said its fyn.   but  i add more bar values ok i can do it inline.

wen i want to apply to the same to other charts to be apply?

how can i? suppose i hve 10 colours   so that 10 colurs as default  and that shud be reflct to any chart i creates.?

[tresesco · Accepted solution]

Set your calculated colors as shown in happy.qvw and then update this color scheme in advanced settings (Document Default) like:

[Chanty4u]

Excellent.Perfect.

Thanks

Suresh