Custom palette in pie chart

Hi there!
I'v been trying to figure this out for a while, I have a Pie chart for
which I want to set the colors of the pies to my own defined colors.
The source dataset may contain 0 to 15 values, I've tried the folowing
solutions but none seem to work.
When column bouncetype is "HARD_BOUNCE" the pie should be green, etc...
=Switch
(
First(Fields!BounceType.Value,
"MailMessageBounceByType")="HARD_BOUNCE","GREEN",
First(Fields!BounceType.Value, "MailMessageBounceByType")="UNKNOWN","BLUE",
First(Fields!BounceType.Value,
"MailMessageBounceByType")="SPAM_NOTIFICATION","RED"
)
And also an iif statement.
=Iif(First(Fields!BounceType.Value,
"MailMessageBounceByType")="HARD_BOUNCE","GREEN",
Iif(First(Fields!BounceType.Value, "MailMessageBounceByType")="UNKNOWN",
"Red","Blue"))
Any ideas?If I have understoood correctly what you need is to set up colors in your
pie chart setting a color per group.
So, right click on the chart > Properties > Data Tab > Edit your value >
Appeareance tab > Series style > fill > Color > and the put the expression:
= iif(Fields!BounceType.Value, "HARD_BOUNCE","GREEN",
iif(Fields!BounceType.Value, "Red","Blue"))
"Peter Larsson" <scapecom@.hotmail.com> escribió en el mensaje
news:ellRTIHIIHA.3400@.TK2MSFTNGP03.phx.gbl...
> Hi there!
> I'v been trying to figure this out for a while, I have a Pie chart for
> which I want to set the colors of the pies to my own defined colors.
> The source dataset may contain 0 to 15 values, I've tried the folowing
> solutions but none seem to work.
> When column bouncetype is "HARD_BOUNCE" the pie should be green, etc...
> =Switch
> (
> First(Fields!BounceType.Value,
> "MailMessageBounceByType")="HARD_BOUNCE","GREEN",
> First(Fields!BounceType.Value,
> "MailMessageBounceByType")="UNKNOWN","BLUE",
> First(Fields!BounceType.Value,
> "MailMessageBounceByType")="SPAM_NOTIFICATION","RED"
> )
> And also an iif statement.
> =Iif(First(Fields!BounceType.Value,
> "MailMessageBounceByType")="HARD_BOUNCE","GREEN",
> Iif(First(Fields!BounceType.Value, "MailMessageBounceByType")="UNKNOWN",
> "Red","Blue"))
> Any ideas?|||Hi Monica, thanks for your reply!
Well, that's exactly what I did. ;)
I solved it though, by putting code in the Code-Tab, it's a smoother
solution I think.
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
Regards,
Peter Larsson
Mónica wrote:
> If I have understoood correctly what you need is to set up colors in your
> pie chart setting a color per group.
> So, right click on the chart > Properties > Data Tab > Edit your value >
> Appeareance tab > Series style > fill > Color > and the put the expression:
> = iif(Fields!BounceType.Value, "HARD_BOUNCE","GREEN",
> iif(Fields!BounceType.Value, "Red","Blue"))
>
> "Peter Larsson" <scapecom@.hotmail.com> escribió en el mensaje
> news:ellRTIHIIHA.3400@.TK2MSFTNGP03.phx.gbl...
>> Hi there!
>> I'v been trying to figure this out for a while, I have a Pie chart for
>> which I want to set the colors of the pies to my own defined colors.
>> The source dataset may contain 0 to 15 values, I've tried the folowing
>> solutions but none seem to work.
>> When column bouncetype is "HARD_BOUNCE" the pie should be green, etc...
>> =Switch
>> (
>> First(Fields!BounceType.Value,
>> "MailMessageBounceByType")="HARD_BOUNCE","GREEN",
>> First(Fields!BounceType.Value,
>> "MailMessageBounceByType")="UNKNOWN","BLUE",
>> First(Fields!BounceType.Value,
>> "MailMessageBounceByType")="SPAM_NOTIFICATION","RED"
>> )
>> And also an iif statement.
>> =Iif(First(Fields!BounceType.Value,
>> "MailMessageBounceByType")="HARD_BOUNCE","GREEN",
>> Iif(First(Fields!BounceType.Value, "MailMessageBounceByType")="UNKNOWN",
>> "Red","Blue"))
>> Any ideas?
>