Constants

TYPE_BARCHART

TYPE_BARCHART = 'barChart'

TYPE_BARCHART_3D

TYPE_BARCHART_3D = 'bar3DChart'

TYPE_LINECHART

TYPE_LINECHART = 'lineChart'

TYPE_LINECHART_3D

TYPE_LINECHART_3D = 'line3DChart'

TYPE_AREACHART

TYPE_AREACHART = 'areaChart'

TYPE_AREACHART_3D

TYPE_AREACHART_3D = 'area3DChart'

TYPE_PIECHART

TYPE_PIECHART = 'pieChart'

TYPE_PIECHART_3D

TYPE_PIECHART_3D = 'pie3DChart'

TYPE_DOUGHNUTCHART

TYPE_DOUGHNUTCHART = 'doughnutChart'

TYPE_DONUTCHART

TYPE_DONUTCHART = self::TYPE_DOUGHNUTCHART

TYPE_SCATTERCHART

TYPE_SCATTERCHART = 'scatterChart'

TYPE_SURFACECHART

TYPE_SURFACECHART = 'surfaceChart'

TYPE_SURFACECHART_3D

TYPE_SURFACECHART_3D = 'surface3DChart'

TYPE_RADARCHART

TYPE_RADARCHART = 'radarChart'

TYPE_BUBBLECHART

TYPE_BUBBLECHART = 'bubbleChart'

TYPE_STOCKCHART

TYPE_STOCKCHART = 'stockChart'

TYPE_CANDLECHART

TYPE_CANDLECHART = self::TYPE_STOCKCHART

GROUPING_CLUSTERED

GROUPING_CLUSTERED = 'clustered'

GROUPING_STACKED

GROUPING_STACKED = 'stacked'

GROUPING_PERCENT_STACKED

GROUPING_PERCENT_STACKED = 'percentStacked'

GROUPING_STANDARD

GROUPING_STANDARD = 'standard'

DIRECTION_BAR

DIRECTION_BAR = 'bar'

DIRECTION_HORIZONTAL

DIRECTION_HORIZONTAL = self::DIRECTION_BAR

DIRECTION_COL

DIRECTION_COL = 'col'

DIRECTION_COLUMN

DIRECTION_COLUMN = self::DIRECTION_COL

DIRECTION_VERTICAL

DIRECTION_VERTICAL = self::DIRECTION_COL

STYLE_LINEMARKER

STYLE_LINEMARKER = 'lineMarker'

STYLE_SMOOTHMARKER

STYLE_SMOOTHMARKER = 'smoothMarker'

STYLE_MARKER

STYLE_MARKER = 'marker'

STYLE_FILLED

STYLE_FILLED = 'filled'

EMPTY_AS_GAP

EMPTY_AS_GAP = 'gap'

EMPTY_AS_ZERO

EMPTY_AS_ZERO = 'zero'

EMPTY_AS_SPAN

EMPTY_AS_SPAN = 'span'

Properties

$plotType

$plotType : string

Series Plot Type.

Type

string

$plotGrouping

$plotGrouping : string

Plot Grouping Type.

Type

string

$plotDirection

$plotDirection : string

Plot Direction.

Type

string

$plotStyle

$plotStyle : null|string

Plot Style.

Type

null|string

$plotOrder

$plotOrder : array

Order of plots in Series.

Type

array — of integer

$plotLabel

$plotLabel : array

Plot Label.

Type

array — of DataSeriesValues

$plotCategory

$plotCategory : array

Plot Category.

Type

array — of DataSeriesValues

$smoothLine

$smoothLine : bool

Smooth Line.

Type

bool

$plotValues

$plotValues : array

Plot Values.

Type

array — of DataSeriesValues

Methods

__construct()

__construct(null|mixed  $plotType = null, null|mixed  $plotGrouping = null, int[]  $plotOrder = [], \PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues[]  $plotLabel = [], \PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues[]  $plotCategory = [], \PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues[]  $plotValues = [], null|string  $plotDirection = null, bool  $smoothLine = false, null|string  $plotStyle = null) : mixed

Create a new DataSeries.

Parameters

null|mixed $plotType
null|mixed $plotGrouping
int[] $plotOrder
\PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues[] $plotLabel
\PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues[] $plotCategory
\PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues[] $plotValues
null|string $plotDirection
bool $smoothLine
null|string $plotStyle

Returns

mixed —

getPlotType()

getPlotType() : string

Get Plot Type.

Returns

string —

setPlotType()

setPlotType(string  $plotType) : $this

Set Plot Type.

Parameters

string $plotType

Returns

$this —

getPlotGrouping()

getPlotGrouping() : string

Get Plot Grouping Type.

Returns

string —

setPlotGrouping()

setPlotGrouping(string  $groupingType) : $this

Set Plot Grouping Type.

Parameters

string $groupingType

Returns

$this —

getPlotDirection()

getPlotDirection() : string

Get Plot Direction.

Returns

string —

setPlotDirection()

setPlotDirection(string  $plotDirection) : $this

Set Plot Direction.

Parameters

string $plotDirection

Returns

$this —

getPlotOrder()

getPlotOrder() : int[]

Get Plot Order.

Returns

int[] —

getPlotLabels()

getPlotLabels() : array

Get Plot Labels.

Returns

array —

of DataSeriesValues

getPlotLabelByIndex()

getPlotLabelByIndex(mixed  $index) : \PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues

Get Plot Label by Index.

Parameters

mixed $index

Returns

\PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues —

getPlotCategories()

getPlotCategories() : array

Get Plot Categories.

Returns

array —

of DataSeriesValues

getPlotCategoryByIndex()

getPlotCategoryByIndex(mixed  $index) : \PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues

Get Plot Category by Index.

Parameters

mixed $index

Returns

\PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues —

getPlotStyle()

getPlotStyle() : null|string

Get Plot Style.

Returns

null|string —

setPlotStyle()

setPlotStyle(null|string  $plotStyle) : $this

Set Plot Style.

Parameters

null|string $plotStyle

Returns

$this —

getPlotValues()

getPlotValues() : array

Get Plot Values.

Returns

array —

of DataSeriesValues

getPlotValuesByIndex()

getPlotValuesByIndex(mixed  $index) : \PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues

Get Plot Values by Index.

Parameters

mixed $index

Returns

\PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues —

getPlotSeriesCount()

getPlotSeriesCount() : int

Get Number of Plot Series.

Returns

int —

getSmoothLine()

getSmoothLine() : bool

Get Smooth Line.

Returns

bool —

setSmoothLine()

setSmoothLine(bool  $smoothLine) : $this

Set Smooth Line.

Parameters

bool $smoothLine

Returns

$this —

refresh()

refresh(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $worksheet) : void

Parameters

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $worksheet