Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to change the color of my YTD to something different. how do i do it?
In the expressions, the expressions should have a '+' sign, expand it and you will find something called 'Background Color'. In the Definition box for 'Background Color' write =If(Year='YTD', RGB(250,150,100)) and a different RGB() for Target.
You can google RGB to learn about the 3 numbers and how they describe colors.
hi Emac,
check the multi color option in colors tab of chart properties.
then for first five bars use same color, then for the YTD keep a different one!
Hope it helps,
regards,
Barathiraja
Hello Babs,
I have more than 2 expression and that make multicolor non-function to that chart.
This how i got the YTD.
hi,
under colorstab-->advanced-->u can give color for special segments like total
hope u got it!
Babs,
You mean changing the Total color in Advance will do that? I have tried that didnt work
Dear Emac,
here is your solution let me know if not working
Cheers