Different Colors for Values

Hi NG,
i want different colors for the values in my drilldown-tables
i.e.
if value < 0 the values should be red
if value > 0 the values should be black
any suggests?
frankHI
Go to Properties > Color > Expression
And type: =iif(value < 0, â'redâ', â'blackâ')
:-)
"Frank Matthiesen" wrote:
> Hi NG,
> i want different colors for the values in my drilldown-tables
> i.e.
> if value < 0 the values should be red
> if value > 0 the values should be black
> any suggests?
>
> frank
>
>|||Soan wrote:
> Go to Properties > Color > Expression
> And type: =iif(value < 0, "red", "black")
oh man...so easy!
top...thx a lot
frank|||Folks,
I can't get line color changes to appear in a line chart. Did SP1 provide
color control for the Line chart as well?
Thanks,
Chris
"Frank Matthiesen" wrote:
> Soan wrote:
> > Go to Properties > Color > Expression
> > And type: =iif(value < 0, "red", "black")
> oh man...so easy!
> top...thx a lot
> frank
>
>|||For line charts, the line border color property is what you are looking for.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Borgers" <ChrisBorgers@.discussions.microsoft.com> wrote in message
news:D655C59C-1B8F-4BC3-A9D3-6FD3CA409F79@.microsoft.com...
> Folks,
> I can't get line color changes to appear in a line chart. Did SP1 provide
> color control for the Line chart as well?
> Thanks,
> Chris
> "Frank Matthiesen" wrote:
> > Soan wrote:
> > > Go to Properties > Color > Expression
> > > And type: =iif(value < 0, "red", "black")
> >
> > oh man...so easy!
> > top...thx a lot
> >
> > frank
> >
> >
> >