Colouring series below an SLA

[JamesToft]

Hi,

I've got a simple bar chart graph which has a target figure. If one of the bars drops below below the target figure I want to make that particular bar go red.

I've tried using the following code, but that makes all my bars go red.

Sub CustomizeSeriesStyles( baseLayer As AcChartLayer,
+ overlayLayer As AcChartLayer, studyLayers() As AcChartLayer )

Dim seriesStyle As AcChartSeriesStyle

Set seriesStyle = baseLayer.GetSeriesStyle( 1 )
seriesStyle.SetBackgroundColor( Red )

End Sub

Also I don't know how to incorporate my target in there eg if I have a target of 99%.

Thanks in advance for anyones help

James

 

[ASG0856]

What about an IF THEN Statement in a method override

IF The Series Target >=99% Then
seriesSstyle.backgroundcolor = RED
END IF