I have a bar chart showing two values - how to show in deff colors

[eo]

SQL Server 2005 Reporting Services

I have a bar chart which shows a budget value, with two category fields on the X axis (one for Month, and one for Year). The X-axis is therefore divided into 12 equal parts (one for each month), the every 1 of 12 parts is divided into 2 sub parts (one for 2006 and one for 2007). The chart shows the 2 bars per month correctly, but I would like to change each sub part to a different color. How do I do this?
For example jan 2006 green , and jan 2007 blue, feb 2006 green and feb 2007 blue...

EO
Hertfordshire, England

 

[xlbo]

=iif(Fields!Year.Value = 2006, "Green","Blue")

in the format properties of the bar

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question