posted 2/25/2010 by MikeDavis - Views: [12600]
In my last SSRS 2008 class I was showing the students the chart tools and used color as a series on a chart. It was the product color column from the AdventureWorks 2008 Production.Product table. The series automatically chooses colors based on the color pallete of the chart. This made the report confusing because the colors did not match the product colors.
Right click on the Chart and select Series Properties.
Select the Fill option and click the expression button next to color. Then set the value equal to the color of the produc. This is a field in the dataset.Just remember the colors must be valid Reporting Services colors.
You could also use an expression with an if statement. Something like this:
=iif(Fields!color.Value ="Red","Red",iif(Fields!color.Value = "White","LightGrey","Black"))
This will allow you to change the color based on the expression. That way colors like white, which don't show very well, can be changed.
Hello Mike
Can I change series color in SSRS 2005?
I have not used 2005 in a while. But if I remember correctly, you can do it if you have the dundas chart tools installed.
No, I have not....
You can change the colors assigned to the values. I did it very often especially when I did charting on gender. I made females pink and males blue. Also an expression can be made in a similar fashion as Mike did here. Which btw Mike, what a great example with the colors coming back from the database and using them to format the chart. It may error out if there was a funky color that was unrecognized, but you could probably write some form of expression for those.