Visual cues in bar charts

[#1]

Hello All,

I am trying to make a bar chart having two different colors on basis of months

Example: I want to create a sales report with Year , Month, Date in one Dimension Group and want to visualize bars half yearly, suppose, bars for jan to june should be of blue color and from july to dec should be of red color.

Is it possible to create this type of color patterns.

It would be a great help to figure out this.

Thanks in advance.

[#2]

Hi Nitin

Why donot you use expressions to control conditional formatting.

[#3]

Dear All,

Please help me out with the matter.

It will help me a lot while developing my appppp.....

Thank you

[#4 · Accepted solution]

Yes it's possible

cliq  in  the '+'  at the right of the expression

Then in the background color  create an expression such :

=if(   Month <= 6 , color(1) , color(2))  color(n) is the nth color in the color panel. Adapt to your needs

JJ