CODEWITHSUNDEEP
reporting-services
Amarundo
Amarundo

Reputation: 2397

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

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.

Upvotes: 2

Views: 11230

Answers (1)

Chris Latta
Chris Latta

Reputation: 20560

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.

Upvotes: 3

Related Questions