Series.HasErrorBars Property

Excel Developer Reference

True if the series has error bars. This property isn’t available for 3-D charts. Read/write Boolean.

Syntax

expression.HasErrorBars

expression   A variable that represents a Series object.

Example

This example removes error bars from series one in Chart1. The example should be run on a 2-D line chart that has error bars for series one.

Visual Basic for Applications
  Charts("Chart1").SeriesCollection(1).HasErrorBars = False

See Also