Properties

$_name

$_name : string

Chart Name

Type

string

$_plotVisibleOnly

$_plotVisibleOnly : boolean

Plot Visible Only

Type

boolean

$_displayBlanksAs

$_displayBlanksAs : string

Display Blanks as

Type

string

$_topLeftCellRef

$_topLeftCellRef : string

Top-Left Cell Position

Type

string

$_topLeftXOffset

$_topLeftXOffset : integer

Top-Left X-Offset

Type

integer

$_topLeftYOffset

$_topLeftYOffset : integer

Top-Left Y-Offset

Type

integer

$_bottomRightCellRef

$_bottomRightCellRef : string

Bottom-Right Cell Position

Type

string

$_bottomRightXOffset

$_bottomRightXOffset : integer

Bottom-Right X-Offset

Type

integer

$_bottomRightYOffset

$_bottomRightYOffset : integer

Bottom-Right Y-Offset

Type

integer

Methods

__construct()

__construct(  $name, \PHPExcel_Chart_Title  $title = null, \PHPExcel_Chart_Legend  $legend = null, \PHPExcel_Chart_PlotArea  $plotArea = null,   $plotVisibleOnly = true,   $displayBlanksAs = '0', \PHPExcel_Chart_Title  $xAxisLabel = null, \PHPExcel_Chart_Title  $yAxisLabel = null, \PHPExcel_Chart_Axis  $xAxis = null, \PHPExcel_Chart_Axis  $yAxis = null, \PHPExcel_Chart_GridLines  $majorGridlines = null, \PHPExcel_Chart_GridLines  $minorGridlines = null) 

Create a new PHPExcel_Chart

Parameters

$name
\PHPExcel_Chart_Title $title
\PHPExcel_Chart_Legend $legend
\PHPExcel_Chart_PlotArea $plotArea
$plotVisibleOnly
$displayBlanksAs
\PHPExcel_Chart_Title $xAxisLabel
\PHPExcel_Chart_Title $yAxisLabel
\PHPExcel_Chart_Axis $xAxis
\PHPExcel_Chart_Axis $yAxis
\PHPExcel_Chart_GridLines $majorGridlines
\PHPExcel_Chart_GridLines $minorGridlines

getName()

getName() : string

Get Name

Returns

string

getWorksheet()

getWorksheet() : \PHPExcel_Worksheet

Get Worksheet

Returns

\PHPExcel_Worksheet

setWorksheet()

setWorksheet(\PHPExcel_Worksheet  $pValue = null) : \PHPExcel_Chart

Set Worksheet

Parameters

\PHPExcel_Worksheet $pValue

Throws

\PHPExcel_Chart_Exception

Returns

\PHPExcel_Chart

getPlotVisibleOnly()

getPlotVisibleOnly() : boolean

Get Plot Visible Only

Returns

boolean

setPlotVisibleOnly()

setPlotVisibleOnly(boolean  $plotVisibleOnly = true) : \PHPExcel_Chart

Set Plot Visible Only

Parameters

boolean $plotVisibleOnly

Returns

\PHPExcel_Chart

getDisplayBlanksAs()

getDisplayBlanksAs() : string

Get Display Blanks as

Returns

string

setDisplayBlanksAs()

setDisplayBlanksAs(string  $displayBlanksAs = '0') : \PHPExcel_Chart

Set Display Blanks as

Parameters

string $displayBlanksAs

Returns

\PHPExcel_Chart

setTopLeftPosition()

setTopLeftPosition(string  $cell, integer  $xOffset = null, integer  $yOffset = null) : \PHPExcel_Chart

Set the Top Left position for the chart

Parameters

string $cell
integer $xOffset
integer $yOffset

Returns

\PHPExcel_Chart

getTopLeftPosition()

getTopLeftPosition() : array

Get the top left position of the chart

Returns

array —

an associative array containing the cell address, X-Offset and Y-Offset from the top left of that cell

getTopLeftCell()

getTopLeftCell() : string

Get the cell address where the top left of the chart is fixed

Returns

string

setTopLeftCell()

setTopLeftCell(string  $cell) : \PHPExcel_Chart

Set the Top Left cell position for the chart

Parameters

string $cell

Returns

\PHPExcel_Chart

setTopLeftOffset()

setTopLeftOffset(integer  $xOffset = null, integer  $yOffset = null) : \PHPExcel_Chart

Set the offset position within the Top Left cell for the chart

Parameters

integer $xOffset
integer $yOffset

Returns

\PHPExcel_Chart

getTopLeftOffset()

getTopLeftOffset() : array<mixed,integer>

Get the offset position within the Top Left cell for the chart

Returns

array<mixed,integer>

setTopLeftXOffset()

setTopLeftXOffset(  $xOffset) 

Parameters

$xOffset

getTopLeftXOffset()

getTopLeftXOffset() 

setTopLeftYOffset()

setTopLeftYOffset(  $yOffset) 

Parameters

$yOffset

getTopLeftYOffset()

getTopLeftYOffset() 

setBottomRightPosition()

setBottomRightPosition(string  $cell, integer  $xOffset = null, integer  $yOffset = null) : \PHPExcel_Chart

Set the Bottom Right position of the chart

Parameters

string $cell
integer $xOffset
integer $yOffset

Returns

\PHPExcel_Chart

getBottomRightPosition()

getBottomRightPosition() : array

Get the bottom right position of the chart

Returns

array —

an associative array containing the cell address, X-Offset and Y-Offset from the top left of that cell

setBottomRightCell()

setBottomRightCell(  $cell) 

Parameters

$cell

getBottomRightCell()

getBottomRightCell() : string

Get the cell address where the bottom right of the chart is fixed

Returns

string

setBottomRightOffset()

setBottomRightOffset(integer  $xOffset = null, integer  $yOffset = null) : \PHPExcel_Chart

Set the offset position within the Bottom Right cell for the chart

Parameters

integer $xOffset
integer $yOffset

Returns

\PHPExcel_Chart

getBottomRightOffset()

getBottomRightOffset() : array<mixed,integer>

Get the offset position within the Bottom Right cell for the chart

Returns

array<mixed,integer>

setBottomRightXOffset()

setBottomRightXOffset(  $xOffset) 

Parameters

$xOffset

getBottomRightXOffset()

getBottomRightXOffset() 

setBottomRightYOffset()

setBottomRightYOffset(  $yOffset) 

Parameters

$yOffset

getBottomRightYOffset()

getBottomRightYOffset() 

refresh()

refresh() 

render()

render(  $outputDestination = null) 

Parameters

$outputDestination