need help!!! how to fix pie slices in SQL Reporting Services?

would it be possible to have a uniform color for pie slices..
i mean if im going to made 3 charts with the same categories, it should have uniform color....

For example:
Chart1
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

Chart2
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

Chart3
+America -- Green
+Philippines -- Red
+India -- Blue
+Japan -- Pink

So then, how can i pick color for pie slices in Excel and SQL Reporting Services? I need it ASAP!!! Thanks in advance :)

Please check the following article and sample: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx

One part of the article describes how to define and use a custom color palette (this is what you are looking for). In your case, you would just make all the pie charts call the same function to get the color values.

Alternatively (but this is more work and less efficient), you could use an IIF function call on every datapoint to dynamically determine the colors. E.g. =iif(Fields!Region.Value = "America", "Green", iif(Fields!Region.Value = "India", "Blue", .... ))

-- Robert|||

How do i set the color of the datapoint in a pie chart.

Regards,

Karen

|||

I got that to work but i have one problem if my values contain

40%,30%, 30% the color repeats for the second 30% and 30% how can i get a different color for each of the 30%.

Any help will be appreciated.

Regards

Karen