Skip to main content
Announcements
Happy New Year! Cheers to another year of collaboration, connections and success.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Changing color for your bars in bar chart

YTD.JPG.jpg

I want to change the color of my YTD to something different. how do i do it?

1 Solution

Accepted Solutions
qlikpahadi07
Specialist
Specialist

Dear Emac,

here is your solution let me know if not working

Untitled.png

Cheers

View solution in original post

7 Replies
Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

Hello Babs,

I have more than 2 expression and that make multicolor non-function to that chart.

Not applicable
Author

This how i got the YTD.

YTD.JPG.jpg

Not applicable
Author

hi,

under colorstab-->advanced-->u can give color for special segments like total

hope u got it!

Not applicable
Author

Babs,

You mean changing the Total color in Advance will do that? I have tried that didnt work

qlikpahadi07
Specialist
Specialist

Dear Emac,

here is your solution let me know if not working

Untitled.png

Cheers