Series.ErrorBar (PowerPoint)
Applies error bars to the series.
ErrorBar (Direction, Include, Type, Amount, MinusValues)
ActivePresentation.Slides(1).Shapes(1).Chart.FullSeriesCollection(1).ErrorBar Direction:=xlChartX, Include:=xlErrorBarIncludeBoth, Type:=xlErrorBarTypeCustom
Arguments
The following arguments are required:
Direction (XlErrorBarDirection) - One of the enumeration values that specifies the error bar direction.
Possible return values are xlChartX - Bars run parallel to the y-axis for x-axis values, xlChartY - Bars run parallel to the x-axis for y-axis values.
Include (XlErrorBarInclude) - One of the enumeration values that specifies the error bar parts to include.
Possible values are
| xlErrorBarIncludeBoth | Both the positive and negative error range. |
| xlErrorBarIncludeMinusValues | Only the negative error range. |
| xlErrorBarIncludeNone | No error bar range. |
| xlErrorBarIncludePlusValues | Only the positive error range. |
Type (XlErrorBarType) - One of the enumeration values that specifies the error bar type.
Possible values are
| xlErrorBarTypeCustom | The range is set by fixed values or cell values. |
| xlErrorBarTypeFixedValue | Fixed-length error bars. |
| xlErrorBarTypePercent | The percentage of the range to be covered by the error bars. |
| xlErrorBarTypeStDev | Shows the range for a specified number of standard deviations. |
| xlErrorBarTypeStError | Shows the standard error range. |
Optional arguments
The following arguments are optional
Amount (XlErrorBarType) - The error amount. Used for only the positive error amount when Type is xlErrorBarTypeCustom.
Possible values are
| xlErrorBarTypeCustom | The range is set by fixed values or cell values. |
| xlErrorBarTypeFixedValue | Fixed-length error bars. |
| xlErrorBarTypePercent | The percentage of the range to be covered by the error bars. |
| xlErrorBarTypeStDev | Shows the range for a specified number of standard deviations. |
| xlErrorBarTypeStError | Shows the standard error range. |
MinusValues (XlErrorBarType) - The negative error amount when Type is xlErrorBarTypeCustom.
Possible values are
| xlErrorBarTypeCustom | The range is set by fixed values or cell values. |
| xlErrorBarTypeFixedValue | Fixed-length error bars. |
| xlErrorBarTypePercent | The percentage of the range to be covered by the error bars. |
| xlErrorBarTypeStDev | Shows the range for a specified number of standard deviations. |
| xlErrorBarTypeStError | Shows the standard error range. |