Selecting no color for a graphed series

[Brad]

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

 

[Andy Pope]

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