Constants

DATASERIES_TYPE_STRING

DATASERIES_TYPE_STRING = 'String'

DATASERIES_TYPE_NUMBER

DATASERIES_TYPE_NUMBER = 'Number'

Properties

$_dataTypeValues

$_dataTypeValues : 

Type

$_dataType

$_dataType : string

Series Data Type

Type

string

$_dataSource

$_dataSource : string

Series Data Source

Type

string

$_formatCode

$_formatCode : string

Format Code

Type

string

$_marker

$_marker : string

Series Point Marker

Type

string

$_pointCount

$_pointCount : integer

Point Count (The number of datapoints in the dataseries)

Type

integer

$_dataValues

$_dataValues : array

Data Values

Type

array — of mixed

Methods

__construct()

__construct(  $dataType = self::DATASERIES_TYPE_NUMBER,   $dataSource = null,   $formatCode = null,   $pointCount,   $dataValues = array(),   $marker = null) 

Create a new PHPExcel_Chart_DataSeriesValues object

Parameters

$dataType
$dataSource
$formatCode
$pointCount
$dataValues
$marker

getDataType()

getDataType() : string

Get Series Data Type

Returns

string

setDataType()

setDataType(string  $dataType = self::DATASERIES_TYPE_NUMBER) : \PHPExcel_Chart_DataSeriesValues

Set Series Data Type

Parameters

string $dataType

Datatype of this data series Typical values are: PHPExcel_Chart_DataSeriesValues::DATASERIES_TYPE_STRING Normally used for axis point values PHPExcel_Chart_DataSeriesValues::DATASERIES_TYPE_NUMBER Normally used for chart data values

Returns

\PHPExcel_Chart_DataSeriesValues

getDataSource()

getDataSource() : string

Get Series Data Source (formula)

Returns

string

setDataSource()

setDataSource(string  $dataSource = null,   $refreshDataValues = true) : \PHPExcel_Chart_DataSeriesValues

Set Series Data Source (formula)

Parameters

string $dataSource
$refreshDataValues

Returns

\PHPExcel_Chart_DataSeriesValues

getPointMarker()

getPointMarker() : string

Get Point Marker

Returns

string

setPointMarker()

setPointMarker(string  $marker = null) : \PHPExcel_Chart_DataSeriesValues

Set Point Marker

Parameters

string $marker

Returns

\PHPExcel_Chart_DataSeriesValues

getFormatCode()

getFormatCode() : string

Get Series Format Code

Returns

string

setFormatCode()

setFormatCode(string  $formatCode = null) : \PHPExcel_Chart_DataSeriesValues

Set Series Format Code

Parameters

string $formatCode

Returns

\PHPExcel_Chart_DataSeriesValues

getPointCount()

getPointCount() : integer

Get Series Point Count

Returns

integer

isMultiLevelSeries()

isMultiLevelSeries() : boolean

Identify if the Data Series is a multi-level or a simple series

Returns

boolean

multiLevelCount()

multiLevelCount() : boolean

Return the level count of a multi-level Data Series

Returns

boolean

getDataValues()

getDataValues() : array

Get Series Data Values

Returns

array —

of mixed

getDataValue()

getDataValue() : mixed

Get the first Series Data value

Returns

mixed

setDataValues()

setDataValues(array  $dataValues = array(), boolean  $refreshDataSource = TRUE) : \PHPExcel_Chart_DataSeriesValues

Set Series Data Values

Parameters

array $dataValues
boolean $refreshDataSource

TRUE - refresh the value of _dataSource based on the values of $dataValues FALSE - don't change the value of _dataSource

Returns

\PHPExcel_Chart_DataSeriesValues

refresh()

refresh(\PHPExcel_Worksheet  $worksheet,   $flatten = TRUE) 

Parameters

\PHPExcel_Worksheet $worksheet
$flatten

_stripNulls()

_stripNulls(  $var) 

Parameters

$var