I created a toggle button and assigned a small program to it to toggle Y
error bars on and off for a plotted series on a chart. It works great except
I notice that there are little voids on another plotted line on the chart
anywhere it intersects the whited out high-low error bars.

So, can a "no color" choice be selected, and would this work? I have
..ColorIndex = 2 now for whiting out the high low error bars.

My thanks in advance for any direction here.

Brad

Hi,

Doesn't look like the error bars have the option of no colour.
Try a routine along the lines of

With ActiveChart
With .SeriesCollection(1)
.HasErrorBars = Not .HasErrorBars
If .HasErrorBars Then
.ErrorBars.Border.ColorIndex = 2
End If
End With
End With

Cheers
Andy

"Brad" wrote in message
...
I created a toggle button and assigned a small program to it to toggle Y
error bars on and off for a plotted series on a chart. It works great
except I notice that there are little voids on another plotted line on the
chart anywhere it intersects the whited out high-low error bars.

So, can a "no color" choice be selected, and would this work? I have
.ColorIndex = 2 now for whiting out the high low error bars.

My thanks in advance for any direction here.

Brad