Changing the color of month in a bar graph

[#1]

   

I want the months of october and november to be displayed in different colors other than green. Please can anyone help how to do that.

Thanks,

Gaurav

[#2]

Right click --- go to properties and under colors tab you can change the colors of the bar.

[#3]

I know, I want the expression which changes the color of forecast for the month of October and November.

The expression I figured only changes the color when I select those two months but in the default state all of them have same color.

[jagan · Accepted solution]

Hi Gaurav,

Check attached file, hope it helps you.

Regards,

Jagan.

[#5]

Thanks a ton bro thats what I was looking for

[its_anandrjs]

Hi,

In Expression tab by click on plus sign in Background Color write script

if(MonthField = 'october' or MonthField = 'november' , Blue( ),Yellow( ) )

Regards,

Anand

[#7]

I have a formula can u tell me what wrong am I doing in it

sum({1<mSeg={'Total'},mMonth={'$(=only(mMonth))'},mYear={'$(=only(mYear))'}>} mRev.)

It works if I have only two list boxes

sum({1<mSeg={'Total'},mMonth={'$(=only(mMonth))'}>} m Rev.)  Working

but when I have more list boxes it dont

I want to fix the sum to one field of a list box and I want it to change w.r.t other parameters

Can u help Please.

Thanks

Gaurav Tyagi

[#8]

Thanx bro yup I am using that formula