Monday, March 19, 2012

How to change chart color.

Hi,

Anyone can help me on how to set the chart color?

let say i got a pie chart. and i want the color is fix with the data i have. can it be done?

regard

terence chua

i found the solution for this question.

<Style>
<BackgroundGradientEndColor>=Switch( Fields!bKeyId.Value = 5, "Red", Fields!bKeyId.Value = 4, "Blue", Fields!bKeyId.Value = 3, "Yellow", Fields!bKeyId.Value = 2, "Cyan", Fields!bKeyId.Value = 1, "Green")</BackgroundGradientEndColor>
<BackgroundGradientType>VerticalCenter</BackgroundGradientType>
<BackgroundColor>=Switch( Fields!bKeyId.Value = 5, "Red", Fields!bKeyId.Value = 4, "Blue", Fields!bKeyId.Value = 3, "Yellow", Fields!bKeyId.Value = 2, "Cyan", Fields!bKeyId.Value = 1, "Green")</BackgroundColor>
<BorderColor>
<Default>#000001</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>

this is apply on Pie chart. so i can fix the color for every color that i use for same category in different question and report. this make the report look more consitant.

No comments:

Post a Comment