I am using SSRS 2005 to build my report. I have two pie charts on my report that have 3 data points on each chart. The first pie chart shows the current year data (66.69%, 24.84%, 5.57%) and the second pie chart shows the previous year data (88.58%, 9.59%, 1.83%). For some reasons when preview the report, the second pie chart size is bigger than the first pie chart. Is there a way to disable the automatic resizing of the chart? Any help would be appreciated. Tin Trinh

Hi Tin Trinh, From your scenario, I suspect that you have two charts with showing the point labels outside of the pie chart, right? Please correct me if my understanding is wrong. In this case, this behavior you have got is by design at present. When point labels outside of the chart, the labels size increases based on data, and then the actual pie chart width gets reduced automatically. Please try to remove the point labels or show the point labels inside of the chart. And then you can see the two charts have the same size. I have tried this on my test environment and all seems ok. Additionally, if you have any concern about this, please submit a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope Microsoft improve this feature in the next service pack or product release. Thanks for your understanding. Thanks, Eileen

Hi Eileen, Yes, you are correct about the point labels being outside of the pie chart. The reason I have them outside is because it is hard to see with data point with small percentage. I also tried using the legend, but I can't customize the legend data point to the way I wanted. Aethetically, it does not look nice, but it seems this is the way it was designed. I will stick with what I have. Thanks for your reply. Tin

Hi Eileen, Yes, you are correct about the point labels being outside of the pie chart. The reason I have them outside is because it is hard to see with data point with small percentage. I also tried using the legend, but I can't customize the legend data point to the way I wanted. Aethetically, it does not look nice, but it seems this is the way it was designed. I will stick with what I have. Thanks for your reply. Tin

Hi Tin, Just as you said, we can use custom legends as a workaround for this issue. Please refer to Challen Fu’s reply in the following thread: Adding a table (or another legend) in Chart area: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/071ff7d3-7a53-44e3-9f96-00e462f16555/ Additionally, you need to customize the chart color as well in SSRS 2005, please follow the steps as below, 1. Right-click on the field name in “Drop data fields here” pane, and then select Properties. 2. Select “Appearance” tab, and then click “Series Style” at bottom. 3. Change to “Fill” tab in Style Properties, click “fx” button below “Color:” tab. 4. Type in the expression: =Code.GetColor(Fields!field1.Value). 5. Click OK to apply these settings. After complete these steps, you will see the chart like below, Hope that helps you. Thanks, Eileen