Bar chart with part of bars filled with color

[msmichael]

Hi expert, 

Could anyone please let me know how I can create a bar chart like below in QV?

I created the above chart in excel, the last two bars are not filled with colors. I did this by editing the data point. How can I do the same in QV?

Thanks,

Michael

[NW1965]

u should be able to do this by expanding the expression in the expression tab of your chart properties, then going to the background colour and creating an expression in there to control the colour.

For example:

IF(DimensionValue = {'1Q18','2Q18','3Q18','4Q18','1Q19','2019TD'} , RGB (0,0,255) , RGB(0,0,0) )

Note: I might not have the syntax exactly right for the test on the dimension values, you may need to use the match function here, but the principles are there to change the colour using the background expression.

[tresesco · Accepted solution]

Like this?

[msmichael]

Hi,

thanks, this is exactly what I want.