Checking Bar Chart "Values" to change Colors

[jstasz]

 

I am generating a Bar Chart with potential Negative Values.  The Chart has 3 Series.

Is it possible to check the "value" of each bar/series to determine if it is negative or positive so that I can set the color of the bar accordingly?

 

Thanks.

[Frank]

What you are looking for is provided by a piece of functionality we call Conditional Attributes. Check the programmer's guide for details.

[jstasz]

 

I was able to set the conditions and get the bars in the chart to "color" as I want. 

 The issue I have now is with the legend box.  I am changing the color of Series 2, but the legend box shows the default color, not the actual color of the bar.  Is there a way to associate the color code for the legend box series 2 item with the condition?

 Thanks

 

Joyce