Selecting no color for a graphed series

  • Thread starter Thread starter Brad
  • Start date Start date
B

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Error Bars to Series and Colour 1
multiple series bar and line chart 2
For chart syles, why doesn't color order match series order? 1
Eliminate "white space" at edge of area chart data series 2
adding trendline to plots from multiple series 1
How do I specify a constant Y-value for an X-series 2
User Selectable Series and Number of Series for Line Chart 2
XL2007: stock chart- difficulty adding additional series 1

Back
Top