November 3, 2009 at 9:25 pm
I am creating a dashboard sort of report in SSRS 2005 which includes mainly charts...
and i want to change charts color as per my requirements...
How can i change that or how i can create a new palette...??
November 5, 2009 at 9:03 am
Robert Bruckner wrote a terrific article on charting for SSRS that you should read. For your particular case, he has a section on how to create your own custom set of colors for a chart:
http://msdn.microsoft.com/en-us/library/aa964128(SQL.90).aspx
Scroll down to the section in the article titled "Custom Chart Color Palettes and Legends"
Also, regarding charting in general, check out Stephen Few's website http://www.perceptualedge.com -- he specializes in visual analytics and dashboards.
--Pete
November 8, 2009 at 8:11 am
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.
November 18, 2009 at 2:38 pm
is easy, go to chart, properties, Tab Data, in Values, select Button Edit, Tab Apppearance, select button Series Style, Tab Fill,select button fx, and the field write this.
=iif(Fields!Tipo.Value="IN","Blue","Orange")
are the series names.
See you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply