Conditional formatting of lines on charts?

[Zerex71]

Greetings,

Can anyone tell me if there's a way to format portions of lines or
curves on charts? For example, if I have a series of values that dips
below some threshold, it would be nice to see the region of the plot or
curve where it does that. Thanks.

Mike

 

[Guest]

I dunno about changing colors of the line, but you can use graduated fill
colors for the background of a chart area that will clearly show if the value
is in the desirable or undesirable area of the chart..........

Vaya con Dios,
Chuck, CABGx3

 

[Andy Pope]

Hi,

Have a look at
http://www.andypope.info/charts/conditionalline.htm

Cheers
Andy