SeriesCollection.ErrorBar

[y0gster]

I have a chart with series that sometimes contains error bars. I would like to use that chart as reference to other charts on which series contains error bars. Is this possible, knowing which specific serieses contain the error bar?

 

[Andy Pope]

You can use the HasErrorBars property of the series.

Sub x()

    Dim objChart As Chart
    Dim objSeries As Series
    Dim objErrBars As ErrorBars
        
    Set objChart = ActiveSheet.ChartObjects(1).Chart
    
    For Each objSeries In objChart.SeriesCollection
        If objSeries.HasErrorBars Then
            Set objErrBars = objSeries.ErrorBars
            Debug.Print "Has Error bars "; objSeries.Name
        Else
            Debug.Print "Not for "; objSeries.Name
        End If
    Next

End Sub