How to Have Different Colors per Category in a Bar Chart in SSRS 2008 R2

reporting-services

In my Bar Chart I just have 1 series (let's say, sales) and 10 categories (let's say, regions).
I want the bar for each category to display in a different color, automatically.
I could add a SWITCH operation for the "Fill" property, but it's not practical since the category values are data driven and change constantly.

Best Solution

For consistency, you might want to assign a color to each region so they always display with the same color. You could add a RegionColor field to your table and then assign this to the Fill property of your Series Properties:

=Fields!RegionColor.Value

Then whenever your report users see blue, they know it is a certain region, yellow is another region, consistently across all your reports.

This works best for a limited number of regions.

Related Question