Series.ErrorBar Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Applies error bars to the series. Variant.

expression .ErrorBar(Direction, Include, Type, Amount, MinusValues)

expression A variable that represents a Series object.

Parameters

Name

Required/Optional

Data Type

Description

Direction

Required

XlErrorBarDirection

The error bar direction.

Include

Required

XlErrorBarInclude

The error bar parts to include.

Type

Required

XlErrorBarType

The error bar type.

Amount

Optional

Variant

The error amount. Used for only the positive error amount when Type is xlErrorBarTypeCustom.

MinusValues

Optional

Variant

The negative error amount when Type is xlErrorBarTypeCustom.

Return Value

Variant

This example applies standard error bars in the Y direction for series one in Chart1. The error bars are applied in the positive and negative directions. The example should be run on a 2-D line chart.

Charts("Chart1").SeriesCollection(1).ErrorBar _ 
 Direction:=xlY, Include:=xlErrorBarIncludeBoth, _ 
 Type:=xlErrorBarTypeStError

Concepts

Other resources

Show: