Regarding Plot Color to set Background color

[neetu_singh]

Dear All,

I just want to set the background color of a bar chart on the basis of yearmonth as mention below:

Can anybody help on this.

[rajeshvaswani77]

Hi Neetu,

You could go to the expressions then click on the + sign --> background color --> and then give if condition to check the months/year and mention the color using the RGB function.

Hope this helps.

thanks,

Rajesh Vaswani

[#3]

Unfortunately changing the background color of the expression will only change the color of the bars/line.  As far as I know this is not possible in QV.  Interested to see if anyone can figure it out.

[neetu_singh]

Hi Rajesh,

have tried the same but its not working as have two dimension one is yearmonth & second is state. so if i set the background color as mention by you it will change the color of lines not the background.

[Anonymous]

Neetu

Does the attached qvw give you food for thought ?

Best Regards,     Bill

[rwunderlich]

Here's a variation on your idea Bill that handles an variable number of years.

-Rob

http://masterssummit.com

http://robwunderlich.com

[neetu_singh]

Hi Rob,

I want the same but the problem is in my chart there are two dimension because of that its not working.

please help.

Regards

Neetu

[rwunderlich]

Please show how you would want the second dimension to display. I don't see it in your original post.

-Rob