Documentation

Axis extends Properties

in package

• Application

Created by PhpStorm.

Table of Contents

Constants

ANGLE_MULTIPLIER  = 60000

AXIS_LABELS_HIGH  = 'high'

AXIS_LABELS_LOW  = 'low'

AXIS_LABELS_NEXT_TO  = 'nextTo'

AXIS_LABELS_NONE  = 'none'

AXIS_TYPE_CATEGORY  = 'catAx'

AXIS_TYPE_DATE  = 'dateAx'

AXIS_TYPE_VALUE  = 'valAx'

DISP_UNITS_BILLIONS  = 'billions'

DISP_UNITS_BUILTIN_INT  = [100 => self::DISP_UNITS_HUNDREDS, 1000 => self::DISP_UNITS_THOUSANDS, 10000 => self::DISP_UNITS_TEN_THOUSANDS, 100000 => self::DISP_UNITS_HUNDRED_THOUSANDS, 1000000 => self::DISP_UNITS_MILLIONS, 10000000 => self::DISP_UNITS_TEN_MILLIONS, 100000000 => self::DISP_UNITS_HUNDRED_MILLIONS, 1000000000 => self::DISP_UNITS_BILLIONS, self::TRILLION_INDEX => self::DISP_UNITS_TRILLIONS]

DISP_UNITS_HUNDRED_MILLIONS  = 'hundredMillions'

DISP_UNITS_HUNDRED_THOUSANDS  = 'hundredThousands'

DISP_UNITS_HUNDREDS  = 'hundreds'

DISP_UNITS_MILLIONS  = 'millions'

DISP_UNITS_TEN_MILLIONS  = 'tenMillions'

DISP_UNITS_TEN_THOUSANDS  = 'tenThousands'

DISP_UNITS_THOUSANDS  = 'thousands'

DISP_UNITS_TRILLIONS  = 'trillions'

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'

TIME_UNIT_DAYS  = 'days'

TIME_UNIT_MONTHS  = 'months'

TIME_UNIT_YEARS  = 'years'

TRILLION_INDEX  = PHP_INT_SIZE > 4 ? 1000000000000 : '1000000000000'

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']

NUMERIC_FORMAT  = [\PhpOffice\PhpSpreadsheet\Chart\Properties::FORMAT_CODE_NUMBER, \PhpOffice\PhpSpreadsheet\Chart\Properties::FORMAT_CODE_DATE, \PhpOffice\PhpSpreadsheet\Chart\Properties::FORMAT_CODE_DATE_ISO8601]

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>

$axisNumber  : array<string|int, mixed>

Axis Number.

$axisOptions  : array<string, null|string>

Axis Options.

$axisText  : AxisText|null

$axisType  : string

$crossBetween  : string

$dispUnitsTitle  : Title|null

$fillColor  : ChartColor

Fill Properties.

$majorGridlines  : GridLines|null

Chart Major Gridlines as.

$minorGridlines  : GridLines|null

Chart Minor Gridlines as.

$noFill  : bool

Methods

__clone()  : mixed

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

__construct()  : mixed

activateObject()  : $this

Change Object State to True.

angleToXml()  : string

copyLineStyles()  : void

getAxisIsNumericFormat()  : bool

getAxisNumberFormat()  : string

Get Axis Number Format Data Type.

getAxisNumberSourceLinked()  : string

Get Axis Number Source Linked.

getAxisOptionsProperty()  : string|null

Get Axis Options Property.

getAxisText()  : AxisText|null

getAxisType()  : string

getCrossBetween()  : string

getDispUnitsTitle()  : Title|null

getFillColorObject()  : ChartColor

getFillProperty()  : string

Get Fill Property.

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.

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.

getMajorGridlines()  : GridLines|null

getMinorGridlines()  : GridLines|null

getNoFill()  : bool

getObjectState()  : bool

Get Object State.

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

getShadowColorObject()  : ChartColor

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

Get Shadow Property.

getSoftEdgesSize()  : float|null

Get Soft Edges Size.

pointsToXml()  : string

setAxisNumberProperties()  : void

Get Series Data Type.

setAxisOption()  : void

setAxisOptionsProperties()  : void

Set Axis Options Properties.

setAxisOrientation()  : void

Set Axis Orientation Property.

setAxisText()  : self

setAxisType()  : self

setCrossBetween()  : self

setDispUnitsTitle()  : self

setFillParameters()  : void

Set Fill Property.

setGlowProperties()  : void

Set Glow Properties.

setLineColorProperties()  : void

Set Line Color Properties.

setLineStyleArray()  : self

setLineStyleProperties()  : void

Set Line Style Properties.

setLineStyleProperty()  : self

setMajorGridlines()  : self

setMinorGridlines()  : self

setNoFill()  : self

setShadowProperties()  : void

Set Shadow Properties.

setShadowProperty()  : self

setSoftEdges()  : void

Set Soft Edges Size.

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.