Documentation

DataSeriesValues extends Properties
in package

Application

Created by PhpStorm.

User: nhw2h8s Date: 7/2/14 Time: 5:45 PM.

Constants

ANGLE_MULTIPLIER = 60000
AXIS_LABELS_HIGH = 'high'
AXIS_LABELS_LOW = 'low'
AXIS_LABELS_NEXT_TO = 'nextTo'
AXIS_LABELS_NONE = 'none'
DATASERIES_TYPE_NUMBER = 'Number'
DATASERIES_TYPE_STRING = 'String'
FORMAT_CODE_ACCOUNTING = '_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)'
FORMAT_CODE_CURRENCY = '$#,##0.00'
FORMAT_CODE_DATE = 'm/d/yyyy'
FORMAT_CODE_DATE_ISO8601 = 'yyyy-mm-dd'
FORMAT_CODE_FRACTION = '# ?/?'
FORMAT_CODE_GENERAL = 'General'
FORMAT_CODE_NUMBER = '#,##0.00'
FORMAT_CODE_PERCENTAGE = '0.00%'
FORMAT_CODE_SCIENTIFIC = '0.00E+00'
FORMAT_CODE_SPECIAL = '00000'
FORMAT_CODE_TEXT = '@'
FORMAT_CODE_TIME = '[$-F400]h:mm:ss AM/PM'
HORIZONTAL_CROSSES_AUTOZERO = 'autoZero'
HORIZONTAL_CROSSES_MAXIMUM = 'max'
LINE_STYLE_ARROW_SIZE_1 = 1
LINE_STYLE_ARROW_SIZE_2 = 2
LINE_STYLE_ARROW_SIZE_3 = 3
LINE_STYLE_ARROW_SIZE_4 = 4
LINE_STYLE_ARROW_SIZE_5 = 5
LINE_STYLE_ARROW_SIZE_6 = 6
LINE_STYLE_ARROW_SIZE_7 = 7
LINE_STYLE_ARROW_SIZE_8 = 8
LINE_STYLE_ARROW_SIZE_9 = 9
LINE_STYLE_ARROW_TYPE_ARROW = 'triangle'
LINE_STYLE_ARROW_TYPE_DIAMOND = 'diamond'
LINE_STYLE_ARROW_TYPE_NOARROW = null
LINE_STYLE_ARROW_TYPE_OPEN = 'arrow'
LINE_STYLE_ARROW_TYPE_OVAL = 'oval'
LINE_STYLE_ARROW_TYPE_STEALTH = 'stealth'
LINE_STYLE_CAP_FLAT = 'flat'
LINE_STYLE_CAP_ROUND = 'rnd'
LINE_STYLE_CAP_SQUARE = 'sq'
LINE_STYLE_COMPOUND_DOUBLE = 'dbl'
LINE_STYLE_COMPOUND_SIMPLE = 'sng'
LINE_STYLE_COMPOUND_THICKTHIN = 'thickThin'
LINE_STYLE_COMPOUND_THINTHICK = 'thinThick'
LINE_STYLE_COMPOUND_TRIPLE = 'tri'
LINE_STYLE_DASH_DASH_DOT = 'dashDot'
LINE_STYLE_DASH_LONG_DASH = 'lgDash'
LINE_STYLE_DASH_LONG_DASH_DOT = 'lgDashDot'
LINE_STYLE_DASH_LONG_DASH_DOT_DOT = 'lgDashDotDot'
LINE_STYLE_DASH_ROUND_DOT = 'sysDot'
LINE_STYLE_DASH_SOLID = 'solid'
LINE_STYLE_DASH_SQUARE_DOT = 'sysDash'
LINE_STYLE_JOIN_BEVEL = 'bevel'
LINE_STYLE_JOIN_MITER = 'miter'
LINE_STYLE_JOIN_ROUND = 'round'
LINE_STYPE_DASH_DASH = 'dash'
ORIENTATION_NORMAL = 'minMax'
ORIENTATION_REVERSED = 'maxMin'
PERCENTAGE_MULTIPLIER = 100000
POINTS_WIDTH_MULTIPLIER = 12700
SHADOW_PRESETS_INNER_BOTTOM = 11
SHADOW_PRESETS_INNER_BOTTOM_LEFT = 12
SHADOW_PRESETS_INNER_BOTTTOM_RIGHT = 10
SHADOW_PRESETS_INNER_CENTER = 14
SHADOW_PRESETS_INNER_LEFT = 15
SHADOW_PRESETS_INNER_RIGHT = 13
SHADOW_PRESETS_INNER_TOP = 17
SHADOW_PRESETS_INNER_TOP_LEFT = 18
SHADOW_PRESETS_INNER_TOP_RIGHT = 16
SHADOW_PRESETS_NOSHADOW = null
SHADOW_PRESETS_OUTER_BOTTOM = 2
SHADOW_PRESETS_OUTER_BOTTOM_LEFT = 3
SHADOW_PRESETS_OUTER_BOTTTOM_RIGHT = 1
SHADOW_PRESETS_OUTER_CENTER = 5
SHADOW_PRESETS_OUTER_LEFT = 6
SHADOW_PRESETS_OUTER_RIGHT = 4
SHADOW_PRESETS_OUTER_TOP = 8
SHADOW_PRESETS_OUTER_TOP_LEFT = 9
SHADOW_PRESETS_OUTER_TOP_RIGHT = 7
SHADOW_PRESETS_PERSPECTIVE_BELOW = 19
SHADOW_PRESETS_PERSPECTIVE_LOWER_LEFT = 23
SHADOW_PRESETS_PERSPECTIVE_LOWER_RIGHT = 22
SHADOW_PRESETS_PERSPECTIVE_UPPER_LEFT = 21
SHADOW_PRESETS_PERSPECTIVE_UPPER_RIGHT = 20
TICK_MARK_CROSS = 'cross'
TICK_MARK_INSIDE = 'in'
TICK_MARK_NONE = 'none'
TICK_MARK_OUTSIDE = 'out'
ARROW_SIZES = [1 => ['w' => 'sm', 'len' => 'sm'], 2 => ['w' => 'sm', 'len' => 'med'], 3 => ['w' => 'sm', 'len' => 'lg'], 4 => ['w' => 'med', 'len' => 'sm'], 5 => ['w' => 'med', 'len' => 'med'], 6 => ['w' => 'med', 'len' => 'lg'], 7 => ['w' => 'lg', 'len' => 'sm'], 8 => ['w' => 'lg', 'len' => 'med'], 9 => ['w' => 'lg', 'len' => 'lg']]
PRESETS_OPTIONS = [ //NONE 0 => [ 'presets' => self::SHADOW_PRESETS_NOSHADOW, 'effect' => null, //'color' => [ // 'type' => ChartColor::EXCEL_COLOR_TYPE_STANDARD, // 'value' => 'black', // 'alpha' => 40, //], 'size' => ['sx' => null, 'sy' => null, 'kx' => null, 'ky' => null], 'blur' => null, 'direction' => null, 'distance' => null, 'algn' => null, 'rotWithShape' => null, ], //OUTER 1 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 2700000 / self::ANGLE_MULTIPLIER, 'algn' => 'tl', 'rotWithShape' => '0'], 2 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 5400000 / self::ANGLE_MULTIPLIER, 'algn' => 't', 'rotWithShape' => '0'], 3 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 8100000 / self::ANGLE_MULTIPLIER, 'algn' => 'tr', 'rotWithShape' => '0'], 4 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'algn' => 'l', 'rotWithShape' => '0'], 5 => ['effect' => 'outerShdw', 'size' => ['sx' => 102000 / self::PERCENTAGE_MULTIPLIER, 'sy' => 102000 / self::PERCENTAGE_MULTIPLIER], 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'algn' => 'ctr', 'rotWithShape' => '0'], 6 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 10800000 / self::ANGLE_MULTIPLIER, 'algn' => 'r', 'rotWithShape' => '0'], 7 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 18900000 / self::ANGLE_MULTIPLIER, 'algn' => 'bl', 'rotWithShape' => '0'], 8 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 16200000 / self::ANGLE_MULTIPLIER, 'rotWithShape' => '0'], 9 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 13500000 / self::ANGLE_MULTIPLIER, 'algn' => 'br', 'rotWithShape' => '0'], //INNER 10 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 2700000 / self::ANGLE_MULTIPLIER], 11 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 5400000 / self::ANGLE_MULTIPLIER], 12 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 8100000 / self::ANGLE_MULTIPLIER], 13 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER], 14 => ['effect' => 'innerShdw', 'blur' => 114300 / self::POINTS_WIDTH_MULTIPLIER], 15 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 10800000 / self::ANGLE_MULTIPLIER], 16 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 18900000 / self::ANGLE_MULTIPLIER], 17 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 16200000 / self::ANGLE_MULTIPLIER], 18 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 13500000 / self::ANGLE_MULTIPLIER], //perspective 19 => ['effect' => 'outerShdw', 'blur' => 152400 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 317500 / self::POINTS_WIDTH_MULTIPLIER, 'size' => ['sx' => 90000 / self::PERCENTAGE_MULTIPLIER, 'sy' => -19000 / self::PERCENTAGE_MULTIPLIER], 'direction' => 5400000 / self::ANGLE_MULTIPLIER, 'rotWithShape' => '0'], 20 => ['effect' => 'outerShdw', 'blur' => 76200 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 18900000 / self::ANGLE_MULTIPLIER, 'size' => ['sy' => 23000 / self::PERCENTAGE_MULTIPLIER, 'kx' => -1200000 / self::ANGLE_MULTIPLIER], 'algn' => 'bl', 'rotWithShape' => '0'], 21 => ['effect' => 'outerShdw', 'blur' => 76200 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 13500000 / self::ANGLE_MULTIPLIER, 'size' => ['sy' => 23000 / self::PERCENTAGE_MULTIPLIER, 'kx' => 1200000 / self::ANGLE_MULTIPLIER], 'algn' => 'br', 'rotWithShape' => '0'], 22 => ['effect' => 'outerShdw', 'blur' => 76200 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 12700 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 2700000 / self::ANGLE_MULTIPLIER, 'size' => ['sy' => -23000 / self::PERCENTAGE_MULTIPLIER, 'kx' => -800400 / self::ANGLE_MULTIPLIER], 'algn' => 'bl', 'rotWithShape' => '0'], 23 => ['effect' => 'outerShdw', 'blur' => 76200 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 12700 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 8100000 / self::ANGLE_MULTIPLIER, 'size' => ['sy' => -23000 / self::PERCENTAGE_MULTIPLIER, 'kx' => 800400 / self::ANGLE_MULTIPLIER], 'algn' => 'br', 'rotWithShape' => '0'], ]
SHADOW_ARRAY_KEYS = ['size', 'color']
DATA_TYPE_VALUES = [self::DATASERIES_TYPE_STRING, self::DATASERIES_TYPE_NUMBER]

Properties

$glowColor : ChartColor
$glowSize : float|null
$lineColor : ChartColor
$lineStyleProperties : array<string|int, mixed>
$objectState : bool
$shadowColor : ChartColor
$shadowProperties : array<string|int, mixed>
$softEdges : array<string|int, mixed>
$bubble3D : bool
$dataSource : string|null: Series Data Source.
$dataType : string: Series Data Type.
$dataValues : array<string|int, mixed>|null: Data Values.
$fillColor : null|ChartColor|array<string|int, ChartColor>: Fill color (can be array with colors if dataseries have custom colors).
$formatCode : string|null: Format Code.
$labelLayout : Layout|null
$markerBorderColor : ChartColor
$markerFillColor : ChartColor
$pointCount : int: Point Count (The number of datapoints in the dataseries).
$pointMarker : string|null: Series Point Marker.
$pointSize : int: Series Point Size.
$scatterLines : bool
$smoothLine : bool: Smooth Line. Must be specified for both DataSeries and DataSeriesValues.
$trendLines : array<string|int, TrendLine>

Methods

__clone() : mixed: Implement PHP __clone to create a deep clone, not just a shallow copy.
__construct() : mixed: Create a new DataSeriesValues object.
activateObject() : $this: Change Object State to True.
angleToXml() : string
copyLineStyles() : void
getBubble3D() : bool
getDataSource() : string|null: Get Series Data Source (formula).
getDataType() : string: Get Series Data Type.
getDataValue() : mixed: Get the first Series Data value.
getDataValues() : array<string|int, mixed>|null: Get Series Data Values.
getFillColor() : string|array<string|int, string>: Get fill color.
getFillColorObject() : null|ChartColor|array<string|int, ChartColor>: Get fill color object.
getFormatCode() : string|null: Get Series Format Code.
getGlowColor() : null|int|string: Get Glow Color Property.
getGlowColorObject() : ChartColor
getGlowProperty() : null|array<string|int, mixed>|float|int|string: Get Glow Property.
getGlowSize() : float|null: Get Glow Size.
getLabelLayout() : Layout|null
getLineColor() : ChartColor
getLineColorProperty() : null|int|string: Get Line Color Property.
getLineStyleArray() : array<string|int, mixed>
getLineStyleArrowLength() : string|null: Get Line Style Arrow Excel Length.
getLineStyleArrowParameters() : string: Get Line Style Arrow Parameters.
getLineStyleArrowWidth() : string|null: Get Line Style Arrow Width.
getLineStyleProperty() : string|null: Get Line Style Property.
getLineWidth() : null|float|int: Get line width for series.
getMarkerBorderColor() : ChartColor
getMarkerFillColor() : ChartColor
getObjectState() : bool: Get Object State.
getPointCount() : int: Get Series Point Count.
getPointMarker() : string|null: Get Point Marker.
getPointSize() : int: Get Point Size.
getScatterLines() : bool
getShadowArray() : array<string|int, mixed>
getShadowColorObject() : ChartColor
getShadowProperty() : array<string|int, mixed>|string|null: Get Shadow Property.
getSmoothLine() : bool: Get Smooth Line.
getSoftEdgesSize() : float|null: Get Soft Edges Size.
getTrendLines() : array<string|int, mixed>
isMultiLevelSeries() : bool|null: Identify if the Data Series is a multi-level or a simple series.
multiLevelCount() : int: Return the level count of a multi-level Data Series.
pointsToXml() : string
refresh() : void
setBubble3D() : self
setDataSource() : $this: Set Series Data Source (formula).
setDataType() : $this: Set Series Data Type.
setDataValues() : $this: Set Series Data Values.
setFillColor() : $this: Set fill color for series.
setFormatCode() : $this: Set Series Format Code.
setGlowProperties() : void: Set Glow Properties.
setLabelLayout() : self
setLineColorProperties() : void: Set Line Color Properties.
setLineStyleArray() : self
setLineStyleProperties() : void: Set Line Style Properties.
setLineStyleProperty() : self
setLineWidth() : $this: Set line width for the series.
setPointMarker() : $this: Set Point Marker.
setPointSize() : $this: Set Point Size.
setScatterLines() : self
setShadowProperties() : void: Set Shadow Properties.
setShadowProperty() : self
setSmoothLine() : $this: Set Smooth Line.
setSoftEdges() : void: Set Soft Edges Size.
setTrendLines() : self
tenthOfPercentToXml() : string
xmlToAngle() : float
xmlToPoints() : float
xmlToTenthOfPercent() : float
getArrayElementsValue() : mixed: Get value of array element.
getLineStyleArrowSize() : string: Get Line Style Arrow Size.
getShadowPresetsMap() : array<string|int, mixed>
setColorProperties() : array<string|int, mixed>
setGlowSize() : $this: Set Glow Size.
setShadowAngle() : $this: Set Shadow Angle.
setShadowBlur() : $this: Set Shadow Blur.
setShadowDistance() : $this: Set Shadow Distance.
setShadowPresetsProperties() : $this: Set Shadow Presets Properties.
setShadowPropertiesMapValues() : $this: Set Shadow Properties Values.
chartColorToString() : string
stringToChartColor() : ChartColor
validateColor() : bool: Method for validating hex color.

ANGLE_MULTIPLIER


    public
        mixed
    ANGLE_MULTIPLIER
    = 60000

AXIS_LABELS_HIGH


    public
        mixed
    AXIS_LABELS_HIGH
    = 'high'

AXIS_LABELS_LOW


    public
        mixed
    AXIS_LABELS_LOW
    = 'low'

AXIS_LABELS_NEXT_TO


    public
        mixed
    AXIS_LABELS_NEXT_TO
    = 'nextTo'

AXIS_LABELS_NONE


    public
        mixed
    AXIS_LABELS_NONE
    = 'none'

DATASERIES_TYPE_NUMBER


    public
        mixed
    DATASERIES_TYPE_NUMBER
    = 'Number'

DATASERIES_TYPE_STRING


    public
        mixed
    DATASERIES_TYPE_STRING
    = 'String'

FORMAT_CODE_ACCOUNTING


    public
        mixed
    FORMAT_CODE_ACCOUNTING
    = '_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)'

FORMAT_CODE_CURRENCY


    public
        mixed
    FORMAT_CODE_CURRENCY
    = '$#,##0.00'

FORMAT_CODE_DATE


    public
        mixed
    FORMAT_CODE_DATE
    = 'm/d/yyyy'

FORMAT_CODE_DATE_ISO8601


    public
        mixed
    FORMAT_CODE_DATE_ISO8601
    = 'yyyy-mm-dd'

FORMAT_CODE_FRACTION


    public
        mixed
    FORMAT_CODE_FRACTION
    = '# ?/?'

FORMAT_CODE_GENERAL


    public
        mixed
    FORMAT_CODE_GENERAL
    = 'General'

FORMAT_CODE_NUMBER


    public
        mixed
    FORMAT_CODE_NUMBER
    = '#,##0.00'

FORMAT_CODE_PERCENTAGE


    public
        mixed
    FORMAT_CODE_PERCENTAGE
    = '0.00%'

FORMAT_CODE_SCIENTIFIC


    public
        mixed
    FORMAT_CODE_SCIENTIFIC
    = '0.00E+00'

FORMAT_CODE_SPECIAL


    public
        mixed
    FORMAT_CODE_SPECIAL
    = '00000'

FORMAT_CODE_TEXT


    public
        mixed
    FORMAT_CODE_TEXT
    = '@'

FORMAT_CODE_TIME


    public
        mixed
    FORMAT_CODE_TIME
    = '[$-F400]h:mm:ss AM/PM'

HORIZONTAL_CROSSES_AUTOZERO


    public
        mixed
    HORIZONTAL_CROSSES_AUTOZERO
    = 'autoZero'

HORIZONTAL_CROSSES_MAXIMUM


    public
        mixed
    HORIZONTAL_CROSSES_MAXIMUM
    = 'max'

LINE_STYLE_ARROW_SIZE_1


    public
        mixed
    LINE_STYLE_ARROW_SIZE_1
    = 1

LINE_STYLE_ARROW_SIZE_2


    public
        mixed
    LINE_STYLE_ARROW_SIZE_2
    = 2

LINE_STYLE_ARROW_SIZE_3


    public
        mixed
    LINE_STYLE_ARROW_SIZE_3
    = 3

LINE_STYLE_ARROW_SIZE_4


    public
        mixed
    LINE_STYLE_ARROW_SIZE_4
    = 4

LINE_STYLE_ARROW_SIZE_5


    public
        mixed
    LINE_STYLE_ARROW_SIZE_5
    = 5

LINE_STYLE_ARROW_SIZE_6


    public
        mixed
    LINE_STYLE_ARROW_SIZE_6
    = 6

LINE_STYLE_ARROW_SIZE_7


    public
        mixed
    LINE_STYLE_ARROW_SIZE_7
    = 7

LINE_STYLE_ARROW_SIZE_8


    public
        mixed
    LINE_STYLE_ARROW_SIZE_8
    = 8

LINE_STYLE_ARROW_SIZE_9


    public
        mixed
    LINE_STYLE_ARROW_SIZE_9
    = 9

LINE_STYLE_ARROW_TYPE_ARROW


    public
        mixed
    LINE_STYLE_ARROW_TYPE_ARROW
    = 'triangle'

LINE_STYLE_ARROW_TYPE_DIAMOND


    public
        mixed
    LINE_STYLE_ARROW_TYPE_DIAMOND
    = 'diamond'

LINE_STYLE_ARROW_TYPE_NOARROW


    public
        mixed
    LINE_STYLE_ARROW_TYPE_NOARROW
    = null

LINE_STYLE_ARROW_TYPE_OPEN


    public
        mixed
    LINE_STYLE_ARROW_TYPE_OPEN
    = 'arrow'

LINE_STYLE_ARROW_TYPE_OVAL


    public
        mixed
    LINE_STYLE_ARROW_TYPE_OVAL
    = 'oval'

LINE_STYLE_ARROW_TYPE_STEALTH


    public
        mixed
    LINE_STYLE_ARROW_TYPE_STEALTH
    = 'stealth'

LINE_STYLE_CAP_FLAT


    public
        mixed
    LINE_STYLE_CAP_FLAT
    = 'flat'

LINE_STYLE_CAP_ROUND


    public
        mixed
    LINE_STYLE_CAP_ROUND
    = 'rnd'

LINE_STYLE_CAP_SQUARE


    public
        mixed
    LINE_STYLE_CAP_SQUARE
    = 'sq'

LINE_STYLE_COMPOUND_DOUBLE


    public
        mixed
    LINE_STYLE_COMPOUND_DOUBLE
    = 'dbl'

LINE_STYLE_COMPOUND_SIMPLE


    public
        mixed
    LINE_STYLE_COMPOUND_SIMPLE
    = 'sng'

LINE_STYLE_COMPOUND_THICKTHIN


    public
        mixed
    LINE_STYLE_COMPOUND_THICKTHIN
    = 'thickThin'

LINE_STYLE_COMPOUND_THINTHICK


    public
        mixed
    LINE_STYLE_COMPOUND_THINTHICK
    = 'thinThick'

LINE_STYLE_COMPOUND_TRIPLE


    public
        mixed
    LINE_STYLE_COMPOUND_TRIPLE
    = 'tri'

LINE_STYLE_DASH_DASH_DOT


    public
        mixed
    LINE_STYLE_DASH_DASH_DOT
    = 'dashDot'

LINE_STYLE_DASH_LONG_DASH


    public
        mixed
    LINE_STYLE_DASH_LONG_DASH
    = 'lgDash'

LINE_STYLE_DASH_LONG_DASH_DOT


    public
        mixed
    LINE_STYLE_DASH_LONG_DASH_DOT
    = 'lgDashDot'

LINE_STYLE_DASH_LONG_DASH_DOT_DOT


    public
        mixed
    LINE_STYLE_DASH_LONG_DASH_DOT_DOT
    = 'lgDashDotDot'

LINE_STYLE_DASH_ROUND_DOT


    public
        mixed
    LINE_STYLE_DASH_ROUND_DOT
    = 'sysDot'

LINE_STYLE_DASH_SOLID


    public
        mixed
    LINE_STYLE_DASH_SOLID
    = 'solid'

LINE_STYLE_DASH_SQUARE_DOT


    public
        mixed
    LINE_STYLE_DASH_SQUARE_DOT
    = 'sysDash'

LINE_STYLE_JOIN_BEVEL


    public
        mixed
    LINE_STYLE_JOIN_BEVEL
    = 'bevel'

LINE_STYLE_JOIN_MITER


    public
        mixed
    LINE_STYLE_JOIN_MITER
    = 'miter'

LINE_STYLE_JOIN_ROUND


    public
        mixed
    LINE_STYLE_JOIN_ROUND
    = 'round'

LINE_STYPE_DASH_DASH


    public
        mixed
    LINE_STYPE_DASH_DASH
    = 'dash'

ORIENTATION_NORMAL


    public
        mixed
    ORIENTATION_NORMAL
    = 'minMax'

ORIENTATION_REVERSED


    public
        mixed
    ORIENTATION_REVERSED
    = 'maxMin'

PERCENTAGE_MULTIPLIER


    public
        mixed
    PERCENTAGE_MULTIPLIER
    = 100000

POINTS_WIDTH_MULTIPLIER


    public
        mixed
    POINTS_WIDTH_MULTIPLIER
    = 12700

SHADOW_PRESETS_INNER_BOTTOM


    public
        mixed
    SHADOW_PRESETS_INNER_BOTTOM
    = 11

SHADOW_PRESETS_INNER_BOTTOM_LEFT


    public
        mixed
    SHADOW_PRESETS_INNER_BOTTOM_LEFT
    = 12

SHADOW_PRESETS_INNER_BOTTTOM_RIGHT


    public
        mixed
    SHADOW_PRESETS_INNER_BOTTTOM_RIGHT
    = 10

SHADOW_PRESETS_INNER_CENTER


    public
        mixed
    SHADOW_PRESETS_INNER_CENTER
    = 14

SHADOW_PRESETS_INNER_LEFT


    public
        mixed
    SHADOW_PRESETS_INNER_LEFT
    = 15

SHADOW_PRESETS_INNER_RIGHT


    public
        mixed
    SHADOW_PRESETS_INNER_RIGHT
    = 13

SHADOW_PRESETS_INNER_TOP


    public
        mixed
    SHADOW_PRESETS_INNER_TOP
    = 17

SHADOW_PRESETS_INNER_TOP_LEFT


    public
        mixed
    SHADOW_PRESETS_INNER_TOP_LEFT
    = 18

SHADOW_PRESETS_INNER_TOP_RIGHT


    public
        mixed
    SHADOW_PRESETS_INNER_TOP_RIGHT
    = 16

SHADOW_PRESETS_NOSHADOW


    public
        mixed
    SHADOW_PRESETS_NOSHADOW
    = null

SHADOW_PRESETS_OUTER_BOTTOM


    public
        mixed
    SHADOW_PRESETS_OUTER_BOTTOM
    = 2

SHADOW_PRESETS_OUTER_BOTTOM_LEFT


    public
        mixed
    SHADOW_PRESETS_OUTER_BOTTOM_LEFT
    = 3

SHADOW_PRESETS_OUTER_BOTTTOM_RIGHT


    public
        mixed
    SHADOW_PRESETS_OUTER_BOTTTOM_RIGHT
    = 1

SHADOW_PRESETS_OUTER_CENTER


    public
        mixed
    SHADOW_PRESETS_OUTER_CENTER
    = 5

SHADOW_PRESETS_OUTER_LEFT


    public
        mixed
    SHADOW_PRESETS_OUTER_LEFT
    = 6

SHADOW_PRESETS_OUTER_RIGHT


    public
        mixed
    SHADOW_PRESETS_OUTER_RIGHT
    = 4

SHADOW_PRESETS_OUTER_TOP


    public
        mixed
    SHADOW_PRESETS_OUTER_TOP
    = 8

SHADOW_PRESETS_OUTER_TOP_LEFT


    public
        mixed
    SHADOW_PRESETS_OUTER_TOP_LEFT
    = 9

SHADOW_PRESETS_OUTER_TOP_RIGHT


    public
        mixed
    SHADOW_PRESETS_OUTER_TOP_RIGHT
    = 7

SHADOW_PRESETS_PERSPECTIVE_BELOW


    public
        mixed
    SHADOW_PRESETS_PERSPECTIVE_BELOW
    = 19

SHADOW_PRESETS_PERSPECTIVE_LOWER_LEFT


    public
        mixed
    SHADOW_PRESETS_PERSPECTIVE_LOWER_LEFT
    = 23

SHADOW_PRESETS_PERSPECTIVE_LOWER_RIGHT


    public
        mixed
    SHADOW_PRESETS_PERSPECTIVE_LOWER_RIGHT
    = 22

SHADOW_PRESETS_PERSPECTIVE_UPPER_LEFT


    public
        mixed
    SHADOW_PRESETS_PERSPECTIVE_UPPER_LEFT
    = 21

SHADOW_PRESETS_PERSPECTIVE_UPPER_RIGHT


    public
        mixed
    SHADOW_PRESETS_PERSPECTIVE_UPPER_RIGHT
    = 20

TICK_MARK_CROSS


    public
        mixed
    TICK_MARK_CROSS
    = 'cross'

TICK_MARK_INSIDE


    public
        mixed
    TICK_MARK_INSIDE
    = 'in'

TICK_MARK_NONE


    public
        mixed
    TICK_MARK_NONE
    = 'none'

TICK_MARK_OUTSIDE


    public
        mixed
    TICK_MARK_OUTSIDE
    = 'out'

ARROW_SIZES


    protected
        mixed
    ARROW_SIZES
    = [1 => ['w' => 'sm', 'len' => 'sm'], 2 => ['w' => 'sm', 'len' => 'med'], 3 => ['w' => 'sm', 'len' => 'lg'], 4 => ['w' => 'med', 'len' => 'sm'], 5 => ['w' => 'med', 'len' => 'med'], 6 => ['w' => 'med', 'len' => 'lg'], 7 => ['w' => 'lg', 'len' => 'sm'], 8 => ['w' => 'lg', 'len' => 'med'], 9 => ['w' => 'lg', 'len' => 'lg']]

PRESETS_OPTIONS


    protected
        mixed
    PRESETS_OPTIONS
    = [
    //NONE
    0 => [
        'presets' => self::SHADOW_PRESETS_NOSHADOW,
        'effect' => null,
        //'color' => [
        //    'type' => ChartColor::EXCEL_COLOR_TYPE_STANDARD,
        //    'value' => 'black',
        //    'alpha' => 40,
        //],
        'size' => ['sx' => null, 'sy' => null, 'kx' => null, 'ky' => null],
        'blur' => null,
        'direction' => null,
        'distance' => null,
        'algn' => null,
        'rotWithShape' => null,
    ],
    //OUTER
    1 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 2700000 / self::ANGLE_MULTIPLIER, 'algn' => 'tl', 'rotWithShape' => '0'],
    2 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 5400000 / self::ANGLE_MULTIPLIER, 'algn' => 't', 'rotWithShape' => '0'],
    3 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 8100000 / self::ANGLE_MULTIPLIER, 'algn' => 'tr', 'rotWithShape' => '0'],
    4 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'algn' => 'l', 'rotWithShape' => '0'],
    5 => ['effect' => 'outerShdw', 'size' => ['sx' => 102000 / self::PERCENTAGE_MULTIPLIER, 'sy' => 102000 / self::PERCENTAGE_MULTIPLIER], 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'algn' => 'ctr', 'rotWithShape' => '0'],
    6 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 10800000 / self::ANGLE_MULTIPLIER, 'algn' => 'r', 'rotWithShape' => '0'],
    7 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 18900000 / self::ANGLE_MULTIPLIER, 'algn' => 'bl', 'rotWithShape' => '0'],
    8 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 16200000 / self::ANGLE_MULTIPLIER, 'rotWithShape' => '0'],
    9 => ['effect' => 'outerShdw', 'blur' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 38100 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 13500000 / self::ANGLE_MULTIPLIER, 'algn' => 'br', 'rotWithShape' => '0'],
    //INNER
    10 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 2700000 / self::ANGLE_MULTIPLIER],
    11 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 5400000 / self::ANGLE_MULTIPLIER],
    12 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 8100000 / self::ANGLE_MULTIPLIER],
    13 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER],
    14 => ['effect' => 'innerShdw', 'blur' => 114300 / self::POINTS_WIDTH_MULTIPLIER],
    15 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 10800000 / self::ANGLE_MULTIPLIER],
    16 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 18900000 / self::ANGLE_MULTIPLIER],
    17 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 16200000 / self::ANGLE_MULTIPLIER],
    18 => ['effect' => 'innerShdw', 'blur' => 63500 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 50800 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 13500000 / self::ANGLE_MULTIPLIER],
    //perspective
    19 => ['effect' => 'outerShdw', 'blur' => 152400 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 317500 / self::POINTS_WIDTH_MULTIPLIER, 'size' => ['sx' => 90000 / self::PERCENTAGE_MULTIPLIER, 'sy' => -19000 / self::PERCENTAGE_MULTIPLIER], 'direction' => 5400000 / self::ANGLE_MULTIPLIER, 'rotWithShape' => '0'],
    20 => ['effect' => 'outerShdw', 'blur' => 76200 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 18900000 / self::ANGLE_MULTIPLIER, 'size' => ['sy' => 23000 / self::PERCENTAGE_MULTIPLIER, 'kx' => -1200000 / self::ANGLE_MULTIPLIER], 'algn' => 'bl', 'rotWithShape' => '0'],
    21 => ['effect' => 'outerShdw', 'blur' => 76200 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 13500000 / self::ANGLE_MULTIPLIER, 'size' => ['sy' => 23000 / self::PERCENTAGE_MULTIPLIER, 'kx' => 1200000 / self::ANGLE_MULTIPLIER], 'algn' => 'br', 'rotWithShape' => '0'],
    22 => ['effect' => 'outerShdw', 'blur' => 76200 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 12700 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 2700000 / self::ANGLE_MULTIPLIER, 'size' => ['sy' => -23000 / self::PERCENTAGE_MULTIPLIER, 'kx' => -800400 / self::ANGLE_MULTIPLIER], 'algn' => 'bl', 'rotWithShape' => '0'],
    23 => ['effect' => 'outerShdw', 'blur' => 76200 / self::POINTS_WIDTH_MULTIPLIER, 'distance' => 12700 / self::POINTS_WIDTH_MULTIPLIER, 'direction' => 8100000 / self::ANGLE_MULTIPLIER, 'size' => ['sy' => -23000 / self::PERCENTAGE_MULTIPLIER, 'kx' => 800400 / self::ANGLE_MULTIPLIER], 'algn' => 'br', 'rotWithShape' => '0'],
]

SHADOW_ARRAY_KEYS


    protected
        mixed
    SHADOW_ARRAY_KEYS
    = ['size', 'color']

DATA_TYPE_VALUES


    private
        mixed
    DATA_TYPE_VALUES
    = [self::DATASERIES_TYPE_STRING, self::DATASERIES_TYPE_NUMBER]

$glowColor


    protected
        ChartColor
    $glowColor

$glowSize


    protected
        float|null
    $glowSize
     = null

$lineColor


    protected
        ChartColor
    $lineColor

$lineStyleProperties


    protected
        array<string|int, mixed>
    $lineStyleProperties
     = [
    'width' => null,
    //'9525',
    'compound' => '',
    //self::LINE_STYLE_COMPOUND_SIMPLE,
    'dash' => '',
    //self::LINE_STYLE_DASH_SOLID,
    'cap' => '',
    //self::LINE_STYLE_CAP_FLAT,
    'join' => '',
    //self::LINE_STYLE_JOIN_BEVEL,
    'arrow' => ['head' => [
        'type' => '',
        //self::LINE_STYLE_ARROW_TYPE_NOARROW,
        'size' => '',
        //self::LINE_STYLE_ARROW_SIZE_5,
        'w' => '',
        'len' => '',
    ], 'end' => [
        'type' => '',
        //self::LINE_STYLE_ARROW_TYPE_NOARROW,
        'size' => '',
        //self::LINE_STYLE_ARROW_SIZE_8,
        'w' => '',
        'len' => '',
    ]],
]

$objectState


    protected
        bool
    $objectState
     = false

$shadowColor


    protected
        ChartColor
    $shadowColor

$shadowProperties


    protected
        array<string|int, mixed>
    $shadowProperties
     = self::PRESETS_OPTIONS[0]

$softEdges


    protected
        array<string|int, mixed>
    $softEdges
     = ['size' => null]

$bubble3D


    private
        bool
    $bubble3D
     = false

$dataSource

Series Data Source.


    private
        string|null
    $dataSource

$dataType

Series Data Type.


    private
        string
    $dataType

$dataValues

Data Values.


    private
        array<string|int, mixed>|null
    $dataValues

$fillColor

Fill color (can be array with colors if dataseries have custom colors).


    private
        null|ChartColor|array<string|int, ChartColor>
    $fillColor

$formatCode

Format Code.


    private
        string|null
    $formatCode

$labelLayout


    private
        Layout|null
    $labelLayout
     = null

$markerBorderColor


    private
        ChartColor
    $markerBorderColor

$markerFillColor


    private
        ChartColor
    $markerFillColor

$pointCount

Point Count (The number of datapoints in the dataseries).


    private
        int
    $pointCount

$pointMarker

Series Point Marker.


    private
        string|null
    $pointMarker

$pointSize

Series Point Size.


    private
        int
    $pointSize
     = 3

$scatterLines


    private
        bool
    $scatterLines
     = true

$smoothLine

Smooth Line. Must be specified for both DataSeries and DataSeriesValues.


    private
        bool
    $smoothLine
     = false

$trendLines


    private
        array<string|int, TrendLine>
    $trendLines
     = []

__clone()

Implement PHP __clone to create a deep clone, not just a shallow copy.


    public
                    __clone() : mixed

__construct()

Create a new DataSeriesValues object.


    public
                    __construct([string $dataType = self::DATASERIES_TYPE_NUMBER ][, string|null $dataSource = null ][, string|null $formatCode = null ][, int $pointCount = 0 ][, array<string|int, mixed>|null $dataValues = [] ][, string|null $marker = null ][, null|ChartColor|array<string|int, ChartColor>|string|array<string|int, string> $fillColor = null ][, int|string $pointSize = 3 ]) : mixed

Parameters

$dataType : string = self::DATASERIES_TYPE_NUMBER
$dataSource : string|null = null
$formatCode : string|null = null
$pointCount : int = 0
$dataValues : array<string|int, mixed>|null = []
$marker : string|null = null
$fillColor : null|ChartColor|array<string|int, ChartColor>|string|array<string|int, string> = null
$pointSize : int|string = 3

activateObject()

Change Object State to True.


    public
                    activateObject() : $this

Return values

$this

angleToXml()


    public
            static        angleToXml(float $angle) : string

Parameters

$angle : float

Return values

string

copyLineStyles()


    public
                    copyLineStyles(self $otherProperties) : void

Parameters

$otherProperties : self

getBubble3D()


    public
                    getBubble3D() : bool

Return values

bool

getDataSource()

Get Series Data Source (formula).


    public
                    getDataSource() : string|null

Return values

string|null

getDataType()

Get Series Data Type.


    public
                    getDataType() : string

Return values

string

getDataValue()

Get the first Series Data value.


    public
                    getDataValue() : mixed

getDataValues()

Get Series Data Values.


    public
                    getDataValues() : array<string|int, mixed>|null

Return values

array<string|int, mixed>|null

getFillColor()

Get fill color.


    public
                    getFillColor() : string|array<string|int, string>

Return values

string|array<string|int, string> —

HEX color or array with HEX colors

getFillColorObject()

Get fill color object.


    public
                    getFillColorObject() : null|ChartColor|array<string|int, ChartColor>

Return values

null|ChartColor|array<string|int, ChartColor>

getFormatCode()

Get Series Format Code.


    public
                    getFormatCode() : string|null

Return values

string|null

getGlowColor()

Get Glow Color Property.


    public
                    getGlowColor(string $propertyName) : null|int|string

Parameters

$propertyName : string

Return values

null|int|string

getGlowColorObject()


    public
                    getGlowColorObject() : ChartColor

Return values

ChartColor

getGlowProperty()

Get Glow Property.


    public
                    getGlowProperty(array<string|int, mixed>|string $property) : null|array<string|int, mixed>|float|int|string

Parameters

$property : array<string|int, mixed>|string

Return values

getGlowSize()

Get Glow Size.


    public
                    getGlowSize() : float|null

Return values

float|null

getLabelLayout()


    public
                    getLabelLayout() : Layout|null

Return values

Layout|null

getLineColor()


    public
                    getLineColor() : ChartColor

Return values

ChartColor

getLineColorProperty()

Get Line Color Property.


    public
                    getLineColorProperty(string $propertyName) : null|int|string

Parameters

$propertyName : string

Return values

null|int|string

getLineStyleArray()


    public
                    getLineStyleArray() : array<string|int, mixed>

Return values

array<string|int, mixed>

getLineStyleArrowLength()

Get Line Style Arrow Excel Length.


    public
                    getLineStyleArrowLength(string $arrow) : string|null

Parameters

$arrow : string

Return values

string|null

getLineStyleArrowParameters()

Get Line Style Arrow Parameters.


    public
                    getLineStyleArrowParameters(string $arrowSelector, string $propertySelector) : string

Parameters

$arrowSelector : string
$propertySelector : string

Return values

string

getLineStyleArrowWidth()

Get Line Style Arrow Width.


    public
                    getLineStyleArrowWidth(string $arrow) : string|null

Parameters

$arrow : string

Return values

string|null

getLineStyleProperty()

Get Line Style Property.


    public
                    getLineStyleProperty(array<string|int, mixed>|string $elements) : string|null

Parameters

$elements : array<string|int, mixed>|string

Return values

string|null

getLineWidth()

Get line width for series.


    public
                    getLineWidth() : null|float|int

Return values

null|float|int

getMarkerBorderColor()


    public
                    getMarkerBorderColor() : ChartColor

Return values

ChartColor

getMarkerFillColor()


    public
                    getMarkerFillColor() : ChartColor

Return values

ChartColor

getObjectState()

Get Object State.


    public
                    getObjectState() : bool

Return values

bool

getPointCount()

Get Series Point Count.


    public
                    getPointCount() : int

Return values

int

getPointMarker()

Get Point Marker.


    public
                    getPointMarker() : string|null

Return values

string|null

getPointSize()

Get Point Size.


    public
                    getPointSize() : int

Return values

int

getScatterLines()


    public
                    getScatterLines() : bool

Return values

bool

getShadowArray()


    public
                    getShadowArray() : array<string|int, mixed>

Return values

array<string|int, mixed>

getShadowColorObject()


    public
                    getShadowColorObject() : ChartColor

Return values

ChartColor

getShadowProperty()

Get Shadow Property.


    public
                    getShadowProperty(string|array<string|int, string> $elements) : array<string|int, mixed>|string|null

Parameters

$elements : string|array<string|int, string>

Return values

array<string|int, mixed>|string|null

getSmoothLine()

Get Smooth Line.


    public
                    getSmoothLine() : bool

Return values

bool

getSoftEdgesSize()

Get Soft Edges Size.


    public
                    getSoftEdgesSize() : float|null

Return values

float|null

getTrendLines()


    public
                    getTrendLines() : array<string|int, mixed>

Return values

array<string|int, mixed>

isMultiLevelSeries()

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


    public
                    isMultiLevelSeries() : bool|null

Return values

bool|null

multiLevelCount()

Return the level count of a multi-level Data Series.


    public
                    multiLevelCount() : int

Return values

int

pointsToXml()


    public
            static        pointsToXml(float $width) : string

Parameters

$width : float

Return values

string

refresh()


    public
                    refresh(Worksheet $worksheet[, bool $flatten = true ]) : void

Parameters

$worksheet : Worksheet
$flatten : bool = true

setBubble3D()


    public
                    setBubble3D(bool $bubble3D) : self

Parameters

$bubble3D : bool

Return values

self

setDataSource()

Set Series Data Source (formula).


    public
                    setDataSource(string|null $dataSource) : $this

Parameters

$dataSource : string|null

Return values

$this

setDataType()

Set Series Data Type.


    public
                    setDataType(string $dataType) : $this

Parameters

$dataType : string: Datatype of this data series Typical values are: DataSeriesValues::DATASERIES_TYPE_STRING Normally used for axis point values DataSeriesValues::DATASERIES_TYPE_NUMBER Normally used for chart data values

Return values

$this

setDataValues()

Set Series Data Values.


    public
                    setDataValues(array<string|int, mixed> $dataValues) : $this

Parameters

$dataValues : array<string|int, mixed>

Return values

$this

setFillColor()

Set fill color for series.


    public
                    setFillColor(ChartColor|array<string|int, ChartColor>|string|array<string|int, string> $color) : $this

Parameters

$color : ChartColor|array<string|int, ChartColor>|string|array<string|int, string>: HEX color or array with HEX colors

Return values

$this

setFormatCode()

Set Series Format Code.


    public
                    setFormatCode(string $formatCode) : $this

Parameters

$formatCode : string

Return values

$this

setGlowProperties()

Set Glow Properties.


    public
                    setGlowProperties(float $size[, string|null $colorValue = null ][, int|null $colorAlpha = null ][, string|null $colorType = null ]) : void

Parameters

$size : float
$colorValue : string|null = null
$colorAlpha : int|null = null
$colorType : string|null = null

setLabelLayout()


    public
                    setLabelLayout(Layout|null $labelLayout) : self

Parameters

$labelLayout : Layout|null

Return values

self

setLineColorProperties()

Set Line Color Properties.


    public
                    setLineColorProperties(string|null $value[, int|null $alpha = null ][, string|null $colorType = null ]) : void

Parameters

$value : string|null
$alpha : int|null = null
$colorType : string|null = null

setLineStyleArray()


    public
                    setLineStyleArray([array<string|int, mixed> $lineStyleProperties = [] ]) : self

Parameters

$lineStyleProperties : array<string|int, mixed> = []

Return values

self

setLineStyleProperties()

Set Line Style Properties.


    public
                    setLineStyleProperties([null|float|int|string $lineWidth = null ][, string|null $compoundType = '' ][, string|null $dashType = '' ][, string|null $capType = '' ][, string|null $joinType = '' ][, string|null $headArrowType = '' ][, int $headArrowSize = 0 ][, string|null $endArrowType = '' ][, int $endArrowSize = 0 ][, string|null $headArrowWidth = '' ][, string|null $headArrowLength = '' ][, string|null $endArrowWidth = '' ][, string|null $endArrowLength = '' ]) : void

Parameters

$lineWidth : null|float|int|string = null
$compoundType : string|null = ''
$dashType : string|null = ''
$capType : string|null = ''
$joinType : string|null = ''
$headArrowType : string|null = ''
$headArrowSize : int = 0
$endArrowType : string|null = ''
$endArrowSize : int = 0
$headArrowWidth : string|null = ''
$headArrowLength : string|null = ''
$endArrowWidth : string|null = ''
$endArrowLength : string|null = ''

setLineStyleProperty()


    public
                    setLineStyleProperty(string $propertyName, mixed $value) : self

Parameters

$propertyName : string
$value : mixed

Return values

self

setLineWidth()

Set line width for the series.


    public
                    setLineWidth(null|float|int $width) : $this

Parameters

$width : null|float|int

Return values

$this

setPointMarker()

Set Point Marker.


    public
                    setPointMarker(string $marker) : $this

Parameters

$marker : string

Return values

$this

setPointSize()

Set Point Size.


    public
                    setPointSize([int $size = 3 ]) : $this

Parameters

$size : int = 3

Return values

$this

setScatterLines()


    public
                    setScatterLines(bool $scatterLines) : self

Parameters

$scatterLines : bool

Return values

self

setShadowProperties()

Set Shadow Properties.


    public
                    setShadowProperties(int $presets[, string|null $colorValue = null ][, string|null $colorType = null ][, null|float|int|string $colorAlpha = null ][, float|null $blur = null ][, int|null $angle = null ][, float|null $distance = null ]) : void

Parameters

$presets : int
$colorValue : string|null = null
$colorType : string|null = null
$colorAlpha : null|float|int|string = null
$blur : float|null = null
$angle : int|null = null
$distance : float|null = null

setShadowProperty()


    public
                    setShadowProperty(string $propertyName, mixed $value) : self

Parameters

$propertyName : string
$value : mixed

Return values

self

setSmoothLine()

Set Smooth Line.


    public
                    setSmoothLine(bool $smoothLine) : $this

Parameters

$smoothLine : bool

Return values

$this

setSoftEdges()

Set Soft Edges Size.


    public
                    setSoftEdges(float|null $size) : void

Parameters

$size : float|null

setTrendLines()


    public
                    setTrendLines(array<string|int, mixed> $trendLines) : self

Parameters

$trendLines : array<string|int, mixed>

Return values

self

tenthOfPercentToXml()


    public
            static        tenthOfPercentToXml(float $value) : string

Parameters

$value : float

Return values

string

xmlToAngle()


    public
            static        xmlToAngle(string $angle) : float

Parameters

$angle : string

Return values

float

xmlToPoints()


    public
            static        xmlToPoints(string $width) : float

Parameters

$width : string

Return values

float

xmlToTenthOfPercent()


    public
            static        xmlToTenthOfPercent(string $value) : float

Parameters

$value : string

Return values

float

getArrayElementsValue()

Get value of array element.


    protected
                    getArrayElementsValue(array<string|int, mixed> $properties, array<string|int, mixed>|int|string $elements) : mixed

Parameters

$properties : array<string|int, mixed>
$elements : array<string|int, mixed>|int|string

getLineStyleArrowSize()

Get Line Style Arrow Size.


    protected
                    getLineStyleArrowSize(int $arraySelector, string $arrayKaySelector) : string

Parameters

$arraySelector : int
$arrayKaySelector : string

Return values

string

getShadowPresetsMap()


    protected
                    getShadowPresetsMap(int $presetsOption) : array<string|int, mixed>

Parameters

$presetsOption : int

Return values

array<string|int, mixed>

setColorProperties()


    protected
                    setColorProperties(string|null $color, null|float|int|string $alpha, string|null $colorType) : array<string|int, mixed>

Parameters

$color : string|null
$alpha : null|float|int|string
$colorType : string|null

Return values

array<string|int, mixed>

setGlowSize()

Set Glow Size.


    protected
                    setGlowSize(float|null $size) : $this

Parameters

$size : float|null

Return values

$this

setShadowAngle()

Set Shadow Angle.


    protected
                    setShadowAngle(null|float|int|string $angle) : $this

Parameters

$angle : null|float|int|string

Return values

$this

setShadowBlur()

Set Shadow Blur.


    protected
                    setShadowBlur(float|null $blur) : $this

Parameters

$blur : float|null

Return values

$this

setShadowDistance()

Set Shadow Distance.


    protected
                    setShadowDistance(float|null $distance) : $this

Parameters

$distance : float|null

Return values

$this

setShadowPresetsProperties()

Set Shadow Presets Properties.


    protected
                    setShadowPresetsProperties(int $presets) : $this

Parameters

$presets : int

Return values

$this

setShadowPropertiesMapValues()

Set Shadow Properties Values.


    protected
                    setShadowPropertiesMapValues(array<string|int, mixed> $propertiesMap[, array<string|int, mixed>|null &$reference = null ]) : $this

Parameters

$propertiesMap : array<string|int, mixed>
$reference : array<string|int, mixed>|null = null

Return values

$this

chartColorToString()


    private
                    chartColorToString(ChartColor $chartColor) : string

Parameters

$chartColor : ChartColor

Return values

string

stringToChartColor()


    private
                    stringToChartColor(string $fillString) : ChartColor

Parameters

$fillString : string

Return values

ChartColor

validateColor()

Method for validating hex color.


    private
                    validateColor(string $color) : bool

Parameters

$color : string: value for color

Return values

bool —

true if validation was successful

DataSeriesValues extends Properties in package Application

Table of Contents

Constants

Properties

Methods

Constants

ANGLE_MULTIPLIER

AXIS_LABELS_HIGH

AXIS_LABELS_LOW

AXIS_LABELS_NEXT_TO

AXIS_LABELS_NONE

DATASERIES_TYPE_NUMBER

DATASERIES_TYPE_STRING

FORMAT_CODE_ACCOUNTING

FORMAT_CODE_CURRENCY

FORMAT_CODE_DATE

FORMAT_CODE_DATE_ISO8601

FORMAT_CODE_FRACTION

FORMAT_CODE_GENERAL

FORMAT_CODE_NUMBER

FORMAT_CODE_PERCENTAGE

FORMAT_CODE_SCIENTIFIC

FORMAT_CODE_SPECIAL

FORMAT_CODE_TEXT

FORMAT_CODE_TIME

HORIZONTAL_CROSSES_AUTOZERO

HORIZONTAL_CROSSES_MAXIMUM

LINE_STYLE_ARROW_SIZE_1

LINE_STYLE_ARROW_SIZE_2

LINE_STYLE_ARROW_SIZE_3

LINE_STYLE_ARROW_SIZE_4

LINE_STYLE_ARROW_SIZE_5

LINE_STYLE_ARROW_SIZE_6

LINE_STYLE_ARROW_SIZE_7

LINE_STYLE_ARROW_SIZE_8

LINE_STYLE_ARROW_SIZE_9

LINE_STYLE_ARROW_TYPE_ARROW

LINE_STYLE_ARROW_TYPE_DIAMOND

LINE_STYLE_ARROW_TYPE_NOARROW

LINE_STYLE_ARROW_TYPE_OPEN

LINE_STYLE_ARROW_TYPE_OVAL

LINE_STYLE_ARROW_TYPE_STEALTH

LINE_STYLE_CAP_FLAT

LINE_STYLE_CAP_ROUND

LINE_STYLE_CAP_SQUARE

LINE_STYLE_COMPOUND_DOUBLE

LINE_STYLE_COMPOUND_SIMPLE

LINE_STYLE_COMPOUND_THICKTHIN

LINE_STYLE_COMPOUND_THINTHICK

LINE_STYLE_COMPOUND_TRIPLE

LINE_STYLE_DASH_DASH_DOT

LINE_STYLE_DASH_LONG_DASH

LINE_STYLE_DASH_LONG_DASH_DOT

LINE_STYLE_DASH_LONG_DASH_DOT_DOT

LINE_STYLE_DASH_ROUND_DOT

LINE_STYLE_DASH_SOLID

LINE_STYLE_DASH_SQUARE_DOT

LINE_STYLE_JOIN_BEVEL

LINE_STYLE_JOIN_MITER

LINE_STYLE_JOIN_ROUND

LINE_STYPE_DASH_DASH

ORIENTATION_NORMAL

ORIENTATION_REVERSED

PERCENTAGE_MULTIPLIER

POINTS_WIDTH_MULTIPLIER

SHADOW_PRESETS_INNER_BOTTOM

SHADOW_PRESETS_INNER_BOTTOM_LEFT

SHADOW_PRESETS_INNER_BOTTTOM_RIGHT

SHADOW_PRESETS_INNER_CENTER

SHADOW_PRESETS_INNER_LEFT

SHADOW_PRESETS_INNER_RIGHT

SHADOW_PRESETS_INNER_TOP

SHADOW_PRESETS_INNER_TOP_LEFT

SHADOW_PRESETS_INNER_TOP_RIGHT

SHADOW_PRESETS_NOSHADOW

SHADOW_PRESETS_OUTER_BOTTOM

SHADOW_PRESETS_OUTER_BOTTOM_LEFT

SHADOW_PRESETS_OUTER_BOTTTOM_RIGHT

SHADOW_PRESETS_OUTER_CENTER

SHADOW_PRESETS_OUTER_LEFT

DataSeriesValues extends Properties
in package

Application