Represents the a specific data point in a [[series]].

Constructors

Section titled "Constructors"

DataPoint 

new DataPoint(a: IChartObject): DataPoint

Returns DataPoint

Properties

Section titled "Properties"

$t

Section titled "$t" 
$t: Type

Accessors

Section titled "Accessors"

applyPicToEnd

Section titled "applyPicToEnd"

Returns or sets a value indicating whether a picture is applied to the end of the point or all points in the series.

 
get applyPicToEnd(): boolean | null

Returns boolean | null 

set applyPicToEnd(a: boolean | null): void

Parameters

  • a: boolean | null

Returns void

applyPicToFront

Section titled "applyPicToFront"

Returns or sets a value indicating whether a picture is applied to the front of the point or all points in the series.

 
get applyPicToFront(): boolean | null

Returns boolean | null 

set applyPicToFront(a: boolean | null): void

Parameters

  • a: boolean | null

Returns void

applyPicToSides

Section titled "applyPicToSides"

Returns or sets a value indicating whether a picture is applied to the sides of the point or all points in the series.

 
get applyPicToSides(): boolean | null

Returns boolean | null 

set applyPicToSides(a: boolean | null): void

Parameters

  • a: boolean | null

Returns void

border

Section titled "border"

Determines the appearance of the border drawn around the data point's [[fill]] area.

 
get border(): ChartBorder

Returns ChartBorder 

set border(a: ChartBorder): void

Parameters

Returns void

chart

Section titled "chart"

Inherited from: ChartObject

Returns the owning chart (read-only)

 
get chart(): WorksheetChart

Returns WorksheetChart

dataLabel

Section titled "dataLabel"

Returns or sets a [[dataLabel]] instance which defines the properties of the label displayed for this data point.

 
get dataLabel(): DataLabel

Returns DataLabel 

set dataLabel(a: DataLabel): void

Parameters

Returns void

explosion

Section titled "explosion"

Returns or sets the explosion value for a pie-chart or doughnut-chart slice.

 
get explosion(): number | null

Returns number | null 

set explosion(a: number | null): void

Parameters

  • a: number | null

Returns void

fill

Section titled "fill"

Returns or sets a [[ChartFillBase]] derived object which defines the fill properties for the data point.

 
get fill(): ChartFillBase

Returns ChartFillBase 

set fill(a: ChartFillBase): void

Parameters

Returns void

invertIfNegative

Section titled "invertIfNegative"

Returns or sets a value indicating whether the pattern is inverted in the item when it corresponds to a negative number.

 
get invertIfNegative(): boolean | null

Returns boolean | null 

set invertIfNegative(a: boolean | null): void

Parameters

  • a: boolean | null

Returns void

markerBorder

Section titled "markerBorder"

Determines the appearance of the border (a.k.a. outline) of the marker for this data point.

 
get markerBorder(): ChartBorder

Returns ChartBorder 

set markerBorder(a: ChartBorder): void

Parameters

Returns void

markerFill

Section titled "markerFill"

Defines the fill appearance of the marker for this data point.

 
get markerFill(): ChartFillBase

Returns ChartFillBase 

set markerFill(a: ChartFillBase): void

Parameters

Returns void

markerSize

Section titled "markerSize"

Determines the size of the marker for this data point.

 
get markerSize(): number | null

Returns number | null 

set markerSize(a: number | null): void

Parameters

  • a: number | null

Returns void

markerStyle

Section titled "markerStyle"

Determines the style of the marker for this data point.

 
get markerStyle(): MarkerStyle | null

Returns MarkerStyle | null 

set markerStyle(a: MarkerStyle | null): void

Parameters

Returns void

owner

Section titled "owner"

Inherited from: ChartObject

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

 
get owner(): ChartObject

Returns ChartObject

setAsTotal

Section titled "setAsTotal"

Returns or sets a boolean value indicating whether this data point represents a total or subtotal in a waterfall chart.

 
get setAsTotal(): boolean

Returns boolean 

set setAsTotal(a: boolean): void

Parameters

  • a: boolean

Returns void

sheet

Section titled "sheet"

Inherited from: ChartObject

The owning sheet (read-only)

 
get sheet(): Sheet

Returns Sheet

workbook

Section titled "workbook"

Inherited from: ChartObject

The owning workbook (read-only)

 
get workbook(): Workbook

Returns Workbook

worksheet

Section titled "worksheet"

Inherited from: ChartObject

The owning worksheet (read-only)

 
get worksheet(): Worksheet

Returns Worksheet

Methods

Section titled "Methods"

staticInit

Section titled "staticInit" 
staticInit(): void

Returns void