Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a Bar Chart for 24 months history of stocks. I’vetried to change the colors but in the Chart Properties – Color tab you can onlycontrol 18 of them, is there any way to put that color choice somewhere in theExpression formula?
Thanks in advance..
cheers,
mem
Yes you can, expand the expression by clicking on the plus sign in front of it. Now you will see several options for this expressiion for which you can use another expression including background color. Use the RGB() function to set a color.
You may want to load the colors for each month in a table (linked to your dimension), in which case you must load the R,G and B values seperately. For example fields R,G and B the expression would become =RGB(R,G,B)
Hi,
Yes you are able to set the many colors but you need to set either it in the load statement of the load script and set it from there to change the colors.
Reagrds,
Anand
go to chart properties
-> colors->repeat last 4 color
from here u can control last colors
i.e more than 18 th color wil be same
Yes you can, expand the expression by clicking on the plus sign in front of it. Now you will see several options for this expressiion for which you can use another expression including background color. Use the RGB() function to set a color.
You may want to load the colors for each month in a table (linked to your dimension), in which case you must load the R,G and B values seperately. For example fields R,G and B the expression would become =RGB(R,G,B)
after 18 colors again same colors are repeating
that means
1st and 19 th color will be same
2nd and 20th color will be same
3rd and 21th color will be same
and so on
Hi,
You need to define the 24 colors in the load statement and use that colors in the chart and use the code RGB(value,value,value) and use it as a colors.
Regards,
Anand
Hi,
You need to load inline values for the RGB(value,value,value) and apply all this to your categories. Then use all ths RGB values as color value.
Regards,
Anand