Chart Custom Series Color Problem

We want to use the default palette for all series groups except the first
one, but when we change the bar color of
the first group, all the groups suddenly become the color we set. This works
fine if we change the background for any other group (not the first group).
Is there any way to get around this?
Example:
This makes all of the columns for all of the groups Orange (#FF9933)
=IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "1",
"#FF9933","Transparent")
This works as expected - except it is on the second group.
=IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "2",
"#FF9933","Transparent")
The data that we want to have custom colored has to be the first set.I'm not sure I understand the issue correctly - but the aggregate scope in
the expression seems incorrect. Instead of scoping with the category
grouping, you should scope with the series grouping (assuming there is a
series grouping in the chart).
E.g.:
=IIF( First(Fields!NUM.Value, "chart1_SeriesGroup1") = "2",
"#FF9933","Transparent")
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"debra doty" <debradoty@.discussions.microsoft.com> wrote in message
news:27C5AC1A-8AAC-41A6-BF0B-29FC932AC720@.microsoft.com...
> We want to use the default palette for all series groups except the first
> one, but when we change the bar color of
> the first group, all the groups suddenly become the color we set. This
works
> fine if we change the background for any other group (not the first
group).
> Is there any way to get around this?
> Example:
> This makes all of the columns for all of the groups Orange (#FF9933)
> =IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "1",
> "#FF9933","Transparent")
> This works as expected - except it is on the second group.
> =IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "2",
> "#FF9933","Transparent")
> The data that we want to have custom colored has to be the first set.
>|||Sorry, I copy/pasted my last desperate attempt at getting this to work.
We did use the series grouping scope, it didn't make any difference. In one
report, we group the data by the day of week. The week starts on Sun. We
want all columns in the Sun group to have a backgroud of orange and the rest
of the week to use the default palette. If we make Tues orange this works
fine - but because Sun is the first group, all the columns in all the groups
become orange.
"Robert Bruckner [MSFT]" wrote:
> I'm not sure I understand the issue correctly - but the aggregate scope in
> the expression seems incorrect. Instead of scoping with the category
> grouping, you should scope with the series grouping (assuming there is a
> series grouping in the chart).
> E.g.:
> =IIF( First(Fields!NUM.Value, "chart1_SeriesGroup1") = "2",
> "#FF9933","Transparent")
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "debra doty" <debradoty@.discussions.microsoft.com> wrote in message
> news:27C5AC1A-8AAC-41A6-BF0B-29FC932AC720@.microsoft.com...
> > We want to use the default palette for all series groups except the first
> > one, but when we change the bar color of
> > the first group, all the groups suddenly become the color we set. This
> works
> > fine if we change the background for any other group (not the first
> group).
> > Is there any way to get around this?
> >
> > Example:
> > This makes all of the columns for all of the groups Orange (#FF9933)
> > =IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "1",
> > "#FF9933","Transparent")
> >
> > This works as expected - except it is on the second group.
> > =IIF( First(Fields!NUM.Value, "chart1_CategoryGroup1") = "2",
> > "#FF9933","Transparent")
> >
> > The data that we want to have custom colored has to be the first set.
> >
>
>