SSRS 2008 - Uniform Chart Legends for multi-chart report

Question

Okay, I have a report with multiple charts in it. I have tried a few different ways to get these charts to format the legend the same way, but i have failed. My goal is to make the legends have the same color scheme and ordering across the different charts.

Example, my chart show the count of projects in each of the following funding statuses - not funded, funded, and unknown. No matter what I do, the different charts that I am creating, display the different funding statuses in different order with dfferent colors attached to them. I am using one data source for all charts. Also, the first chart includes all data in the set while the other 3 apply different filters to the data.

Thanks for any help!

Answer 1

Hi

Have a look at point 10 of this article.

http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL%5FReporting/Pie-Chart-Techniques.html

Hope it helps.