Represents the error bars on a chart series. Error bars indicate the degree of uncertainty for chart data. Only series in area, bar, column, line, and scatter groups on a 2-D chart can have error bars. Only series in scatter groups can have x and y error bars. This object isn't a collection. There's no object that represents a single error bar; you either have x error bars or y error bars turned on for all points in a series or you have them turned off.

Hierarchy

Hierarchy (view full)

Constructors

Properties

$type: Type
$t: Type
nextHashCode: number

Accessors

  • get chart(): WorksheetChart
  • Returns the owning chart (read-only)

    See

    [[owner]]

    Returns WorksheetChart

  • get direction(): ErrorBarDirection
  • Returns or sets a value which determines the direction in which the error bars extend from the data points.

    Returns ErrorBarDirection

  • set direction(a): void
  • Parameters

    Returns void

  • get endStyle(): EndStyleCap
  • Returns or sets the end style for the error bars.

    Returns EndStyleCap

  • set endStyle(a): void
  • Parameters

    Returns void

  • get errorValueType(): ErrorValueType
  • Returns or sets a value which determines the units used to evaluate the error.

    Returns ErrorValueType

  • set errorValueType(a): void
  • Parameters

    Returns void

  • get fill(): ChartFillBase
  • Returns or sets a [[ChartFillBase]] derived object which defines the fill color/gradient for the line.

    See

    • [[ChartSolidFill]]
    • [[ChartGradientFill]]

    Returns ChartFillBase

  • set fill(a): void
  • Parameters

    Returns void

  • get owner(): ChartObject
  • returns this object's owner. (read-only) The owner or null if this object is owned directly by the Chart

    See

    [[chart]]

    Returns ChartObject

  • get sheet(): Sheet
  • The owning sheet (read-only)

    Returns Sheet

  • get value(): number
  • Returns or sets a value which defines the error range.

    The unit for this property is determined by the [[errorValueType]] property.

    See

    [[errorValueType]]

    Returns number

  • set value(a): void
  • Parameters

    • a: number

    Returns void

  • get widthInPoints(): number
  • Determines the width of the line, expressed in points.

    A point is a graphical unit equal to 1/72", i.e., there are 72 points in one inch.

    Returns number

  • set widthInPoints(a): void
  • Parameters

    • a: number

    Returns void

  • get workbook(): Workbook
  • The owning workbook (read-only)

    Returns Workbook

  • get worksheet(): Worksheet
  • The owning worksheet (read-only)

    Returns Worksheet

Methods

  • Parameters

    • other: any

    Returns boolean

  • Returns number

  • Returns Base

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns number

  • Parameters

    • item1: any
    • item2: any

    Returns boolean

  • Parameters

    • a: any
    • b: any

    Returns boolean

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns any[]

  • Parameters

    • obj: any

    Returns number

  • Parameters

    • a: any
    • b: any

    Returns boolean