addChart

CONTENTS

LAYOUT AND SETTINGS

TEMPLATES

SAVE

PPTXPATH

FORMAT CONVERSION

PPTXUTILITIES

PPTXCUSTOMIZER

customizeElementStyles

PERFORMANCE

zipStream

CRYPTO

encrypt

DIGITAL SIGNATURE

sign (PPTX)

addChart

BASIC / ADVANCED / PREMIUM

Inserts a chart into the PowerPoint presentation.

Description

public addChart($chart, $position, $chartData, $chartStyles = array(), $options = array())

This method allows the insertion of a chart into the PowerPoint presentation.

This method also allows adding trendlines, grids, labels and many other chart features.

Parameters

chart

Chart type:

area
area3D
bar
bar3D, bar3DCone, bar3DCylinder, bar3DPyramid
bubble
col
col3D, col3DCone, col3DCylinder, col3DPyramid
doughnut
line
line3D
ofPie
pie
pie3D
radar
scatter
surface

position

Key	Type	Description
new	array	A new position is generated. 'coordinateX' (int) EMUs (English Metric Unit). 'coordinateY' (int) EMUs (English Metric Unit). 'sizeX' (int) EMUs (English Metric Unit). 'sizeY' (int) EMUs (English Metric Unit). 'name' (string) internal name. If not set, a random name is generated. 'order' (int) set the display order. Default after existing contents. 0 is the first order position. If the order position doesn't exist add after existing contents.

chartData

Chart data array: legends, labels and values of the chart.

chartStyles

Key	Type	Description
axPos	array	Position of the axis (r, l, t, b). Each value of the array for each position (if a value if null avoids adding it).
color	int	Color scheme.
font	string	The font to be used. Arial, Calibri...
formatCode	string	Number format.
formatDataLabels	array	Possible keys and values are: rotation => (int). position => (string) center, insideEnd, insideBase, outsideEnd.
haxLabel	string	Label for the horizontal axis.
haxLabelDisplay	string	How to display the label of the horizontal axis. Possible values are: vertical, horizontal, rotated.
hgrid	int	Horizontal grid. Possible values are: 0 (no grid) 1 (only major grid lines - default) 2 (only minor grid lines) 3 (both major and minor grid lines)
majorUnit	float	Major unit value for bar, col and line charts.
minorUnit	float	Minor unit value for bar, col and line charts.
orientation	array	Orientation of the axis, from min to max (minMax) or max to min (maxMin). Each value of the array for each axis (if a value if null avoids adding it).
scalingMax	float	Scaling max value for bar, col and line charts.
scalingMin	float	Scaling max value for for bar, col and line charts.
stylesTitle	array	Possible keys and values are: bold (bool) color (string) ffffff, ff0000... font (string) Arial, Times New Roman... fontSize (int) 1420, 2000... Size as drawing content (10 to 400000). 1420 as default italic (bool) layout (array): x (float) 0 < x < 1 y (float) 0 < y < 1
tickLblPos	string	Tick label position (nextTo, high, low, none). If string, uses default values. If array, sets a value for each position.
title	string	The chart title (if any).
vaxLabel	string	Label for the vertical axis.
vaxLabelDisplay	string	How to display the label of the horizontal axis. Possible values are: vertical, horizontal, rotated.
vgrid	int	Vertical grid. Possible values are: 0 (no grid) 1 (only major grid lines - default) 2 (only minor grid lines) 3 (both major and minor grid lines)

The available parameters to display legends and data include:

Key	Type	Description
legendOverlay	bool	If true the legend may overlay the chart.
legendPos	string	The possible values are: b (bottom) l (left) r (right) t (top) none
showCategory	bool	If true shows the categories inside the chart.
showLegendKey	bool	If true shows the legend values.
showPercent	bool	If true shows the percentage values.
showSeries	bool	If true shows the series values.
showTable	bool	If true shows the chart data in an associated table.
showValue	bool	If true shows the chart data values.
trendline	array	Adds trendlines. Compatible with line, bar, col and area 2D charts. Possible keys and values are: 'color' => (string) 0000FF. 'display_equation' => (bool) display equation on chart. 'display_rSquared' => (bool) display R-squared value on chart. 'intercept' => (float) set intercept. 'line_style' => (string) solid, dot, dash, lgDash, dashDot, lgDashDot, lgDashDotDot, sysDash, sysDot, sysDashDot, sysDashDotDot. 'type' => (string) exp, linear, log, poly, power, movingAvg. 'type_order' => (int) for poly and movingAvg types.

Further configuration options for specific chart types are:

Key	Type	Description
Bar and column charts
gapWidth	int	Gap width.
groupBar	string	Different ways to group data. Possible values are: clustered, stacked, percentStacked and standard.
overlap	int	Overlap.
Pie and doughnut charts
explosion	int	Distance between the different values.
holeSize	int	Size of the inner hole (only doughnut charts).
Line charts
smooth	mixed	If true it smooths the line. '0' forces disabling it
symbol	string	The possible symbol values are: Line charts: none, dot, plus, square, star, triangle, x, diamond, circle and dash.
symbolSize	int	The size of the symbol used. From 1 to 73.

Additional available options for 3D charts:

Key	Type	Description
perspective	int	Perspective angle. Angles beyond 25 degrees provoke a big distortion in the 3D chart representation.
rotX	int	Rotation angle with respect to the vertical axis. Standard values are between 10 and 20 degrees.
rotY	int	Rotation angle with respect to the horizontal axis. Standard values are between 10 and 20 degrees.

Theme options (Available in Premium licenses):

Key	Type	Description
chartArea	array	backgroundColor
gridLines	array	capType (string) color (string) dashType (string) width (int)
horizontalAxis	array	textBold (bool) textDirection (string) => horizontal, rotate90, rotate270 textItalic (bool) textSize (int) textUnderline (string) => DrawingML values such as none, sng, dash
legendArea	array	backgroundColor (string) textBold (bool) textItalic (bool) textSize (int) textUnderline (string) => DrawingML values such as none, sng, dash
plotArea	array	backgroundColor
serDataLabels	array	fontStyles (array): bold (bool) color (string): ffffff, ff0000... font (string): Arial, Times New Roman... fontSize (int): size as drawing content (100 to 400000) (100 = 1pt). 1420 as default italic (bool) formatCode (string) position (string) => center, insideEnd, insideBase, outsideEnd showCategory (int) => 0, 1 showLegendKey (int) => 0, 1 showPercent (int) => 0, 1 showSeries (int) => 0, 1 showValue (int) => 0, 1
serRgbColors	array	series colors
valueDataLabels	array	fontStyles (array): bold (bool) color (string): ffffff, ff0000... font (string): Arial, Times New Roman... fontSize (int): size as drawing content (100 to 400000) (100 = 1pt). 1420 as default italic (bool) position (string) => bottom, center, insideEnd, insideBase, left, outsideEnd, right, top, bestFit showCategory (int) => 0, 1 showLegendKey (int) => 0, 1 showPercent (int) => 0, 1 showSeries (int) => 0, 1 showValue (int) => 0, 1 text (string) => this text hides other automatic values
valueRgbColors	array	values colors
verticalAxis	array	textBold (bool) textDirection (string) => horizontal, rotate90, rotate270 textItalic (bool) textSize (int) textUnderline (string) => DrawingML values such as none, sng, dash

Exceptions

Chart type is not supported.

Code samples

Example #1

require_once 'classes/CreatPptx.php';

$pptx = new CreatePptx(array('layout' => 'Blank'));

$position = array(
    'coordinateX' => 2400000,
    'coordinateY' => 2500000,
    'sizeX' => 5000000,
    'sizeY' => 2500000,
);
$dataChart = array(
    'data' => array(
        array(
            'name' => 'data 1',
            'values' => array(10),
        ),
        array(
            'name' => 'data 2',
            'values' => array(20),
        ),
        array(
            'name' => 'data 3',
            'values' => array(50),
        ),
        array(
            'name' => 'data 4',
            'values' => array(25),
        ),
    ),
);
$stylesChart = array(
    'color' => 2,
    'showPercent' => 1,
);
$pptx->addChart('pie3D', $position, $dataChart, $stylesChart);

$pptx->savePptx('output');

The resulting PPTX looks like:

Example #2

require_once 'classes/CreatPptx.php';

$pptx = new CreatePptx(array('layout' => 'Blank'));

$position = array(
    'coordinateX' => 2400000,
    'coordinateY' => 2500000,
    'sizeX' => 5000000,
    'sizeY' => 2500000,
);
$dataChart = array(
    'legend' => array('Legend 1', 'Legend 2', 'Legend 3'),
    'data' => array(
        array(
            'name' => 'data 1',
            'values' => array(10, 20, 5),
        ),
        array(
            'name' => 'data 2',
            'values' => array(20, 60, 3),
        ),
        array(
            'name' => 'data 3',
            'values' => array(50, 33, 7),
        ),
    ),
);
$stylesChart = array(
    'color' => 2,
    'legendOverlay' => false,
    'hgrid' => 1,
    'vgrid' => 2,
);
$pptx->addChart('bar', $position, $dataChart, $stylesChart);

$pptx->savePptx('output');

The resulting PPTX looks like:

Example #3

require_once 'classes/CreatPptx.php';

$pptx = new CreatePptx(array('layout' => 'Blank'));

$position = array(
    'coordinateX' => 2400000,
    'coordinateY' => 2500000,
    'sizeX' => 5000000,
    'sizeY' => 2500000,
);
$dataChart = array(
    'legend' => array('Series 1', 'Series 2', 'Series 3'),
    'data' => array(
        array(
            'name' => 'data 1',
            'values' => array(10, 7, 5),
        ),
        array(
            'name' => 'data 2',
            'values' => array(20, 60, 3),
        ),
        array(
            'name' => 'data 3',
            'values' => array(50, 33, 7),
        ),
        array(
            'name' => 'data 4',
            'values' => array(25, 0, 14),
        ),
    ),
    'trendline' => array(
        array(
            'color' => '0000FF',
            'type' => 'log',
            'displayEquation' => true,
            'displayRSquared' => true,
        ),
        array(),
        array(
            'color' => '0000FF',
            'type' => 'power',
            'lineStyle' => 'dot',
        ),
    ),
);
$stylesChart = array(
    'legendOverlay' => false,
    'haxLabel' => 'X Axis',
    'vaxLabel' => 'Y Axis',
    'haxLabelDisplay' => 'horizontal',
    'vaxLabelDisplay' => 'vertical',
);
$pptx->addChart('line', $position, $dataChart, $stylesChart);

$pptx->savePptx('output');

The resulting PPTX looks like:

Example #4

require_once 'classes/CreatPptx.php';

$pptx = new CreatePptx(array('layout' => 'Blank'));

$position = array(
    'coordinateX' => 2400000,
    'coordinateY' => 2500000,
    'sizeX' => 5000000,
    'sizeY' => 2500000,
);
$dataChart = array(
    'legend' => array('Series 1', 'Series 2', 'Series 3'),
    'data' => array(
        array(
            'name' => 'data 1',
            'values' => array(10, 7, 5),
        ),
        array(
            'name' => 'data 2',
            'values' => array(20, 60, 3),
        ),
        array(
            'name' => 'data 3',
            'values' => array(50, 33, 7),
        ),
        array(
            'name' => 'data 4',
            'values' => array(25, 0, 14),
        ),
    ),
);
$stylesChart = array(
    'color' => 3,
    'legendPos' => 'b',
    'legendOverlay' => false,
    'hgrid' => 3,
    'vgrid' => 0,
    'groupBar' => 'stacked',
    'theme' => array(
        'serRgbColors' => array(null, 'FF00FF', '00FFFF'),
        'valueRgbColors' => array(
            array('FF0000'),
            null,
            array(null, null, '00FF00', '0000FF'),
        ),
    ),
);
$pptx->addChart('col', $position, $dataChart, $stylesChart);

$pptx->savePptx('output');

The resulting PPTX looks like:

Release notes

phppptx 3.5:
- set custom title layout.
- apply font styles to series and values labels.
- valueDataLabels option.

phppptx 3.0:
- ofPie chart type.
- apply custom colors to lines.

phppptx 2.5:
- bubble, radar, scatter and surface chart types.

phppptx 1.0:
- new method.