addChart

LAYOUT & GENERAL

WORD CONTENT

TEMPLATES

FORMAT CONVERSION

DOCXPATH

DOCXUTILITIES

DOCXPATHUTILITIES

PDFUTILITIES

DOCXCUSTOMIZER

customizeWordContent

PERFORMANCE

BULK PROCESSING

TRACKING

CRYPTOPHPDOCX

DIGITAL SIGNATURE

ARTIFICIAL INTELLIGENCE

XLSXUTILITIES

PPTXUTILITIES

BLOCKCHAIN

VARIANT

addChart

TRIAL / ADVANCED / PREMIUM

Inserts a chart into a Word document.

Description

public addChart ( array $options )

This method allows the insertion of a chart into a Word document.

You may insert many different types of 2D and 3D charts:

2D
- Bar (clustered, stacked and 100% stacked).
- Column (clustered, stacked and 100% stacked).
- Pie (simple, exploded, pie of pie and bar of pie).
- Doughnut.
- Line.
- Area.
- Surface.
- Radar.
- XY(scatter).
- Bubble.
3D
- Bar: box (default), cylinder, cone, and pyramid (clustered, stacked and 100% stacked).
- Column: box (default), cylinder, cone, and pyramid (clustered, stacked and 100% stacked).
- Pie (simple and exploded).
- Surface.
- Line.

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

Parameters

Options

This is an array with the following possible keys and values:

Key	Type	Description
data	array	This array should contain the legends and data and to be represented in the following format: 'data' => array( 'legend' => array('Series 1', 'Series 2', 'Series 3'), 'data' => array( array( 'name' => 'data 1', 'values' => array(10, 20, 30), ), array( 'name' => 'data 2', 'values' => array(20, 4, 5), ), array( 'name' => 'data 3', 'values' => array(10, 0, 2), ), ) ) You should omit the legend array in charts for which each data array only contains one value like, for example, pie charts.
type	String	The possible values are: barChart bar3DChart bar3DChartCylinder bar3DChartCone bar3DChartPyramid colChart col3DChart col3DChartCylinder col3DChartCone bar3DChartPyramid pieChart pie3DChart ofPieChart (pie of pie and bar of pie charts) lineChart line3DChart areaChart area3DChart radarChart scatterChart bubbleChart doughnutChart surfaceChart
title	string	The chart title (if any).
border	string	Border width in points.
chartAlign	string	Chart alignment: left (default), right or center.
color	int	Word color scheme for charts: 1: greyscale. 2: default Word color scheme for charts. 3: blue scheme. For the remaining color schemes (up to 48) check the Word interface.
comboChart	string	Chart to add as a combo chart. Use with the returnChart option. Global styles and properties are shared with the base chart. For bar, col, line, area, and radar charts.
customStyle	string	Set external color and styles files imported using the importChartStyle method.
externalXLSX	array	Possible keys and values are: src => (string) path to the external file. occurrences => (array) (optional) by default the option adds all charts of the source file. If occurrences is not empty, it adds the referenced positions. Value from 1.
float	string	Floating chart: left, right or center. It only applies if textWrap is not inline (default value).
font	string	The font to be used. Arial, Calibri...
returnChart	bool	False as default, if true it returns the XML of the chart. To be used with the comboChart option.
sizeX	int	The chart width in centimeters (default value aprox 8.5 cm).
sizeY	int	The chart height in centimeters (default value aprox. 6.0 cm).
textWrap	int	The way text shoud wrap the chart. Possible values are (check the Word interface for the graphical explanation of the different terms): 0 (inline) 1 (square) 2 (front) 3 (back) 4 (up and bottom)
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.

Chart display properties

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).
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	bool	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)
horizontalOffset	int	Given in emus (1cm = 360000 emus).
majorUnit	float	Major unit value for bar, col, line, area, radar and scatter charts.
minorUnit	float	Minor unit value for bar, col, line, area, radar and scatter 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, line, area, radar and scatter charts.
scalingMin	float	Scaling max value for bar, col, line, area, radar and scatter charts.
stylesTitle	array	Possible keys and values are: bold => (boolean). 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 => (boolean).
vaxLabel	string	Label for the vertical axis.
vaxLabelDisplay	bool	How to display the label of the horizontal axis. Possible values are: vertical, horizontal, rotated.
verticalOffset	int	Given in emus (1cm = 360000 emus).
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. This option may hinder the legibility of the data so it is only recommended if it is crucial to "save space".
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.

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.
tickLblPos	string	Tick label position.
Pie and doughnut charts
explosion	int	Distance among different sectors.
holeSize	int	Size of the inner hole (only doughnut charts).
ofPieCharts: pie of pie and bar of pie charts
custSplit	array	Custom split. Array (zero based) of values that goes in the second chart. For example: array(3,4,7) will pick the fourth, fifth and eighth value.
gapWidth	int	Distance between the two charts.
secondPieSize	int	Percentage size of the auxiliary chart.
splitType	string	How to split the two charts. Possible values are: auto (default split type) cust (custom Split) percent (split by percentage) pos (split by position) val (split by value)
splitPos	int	Determines the threshold value to split the charts.
subtype	string	Defines if the auxiliary chart is a pie or bar chart. Possible values are pie or bar.
Line and scatter (XY) 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. Scatter charts: dot and line.
symbolSize	int	The size of the symbol used.
Radar charts
style	string	Defines the radar chart style. Possible values are: radar (lines without dots). marker (lines with dots). filled (filled enclosed area).
Surface charts
wireframe	bool	If true the surface is shown as a wireframe.

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 color dashType width
horizontalAxis	array	textBold textDirection (horizontal, rotate90, rotate270) textItalic textSize textUnderline (DrawingML values such as none, sng, dash)
legendArea	array	backgroundColor textBold textItalic textSize textUnderline
plotArea	array	backgroundColor
serDataLabels	array	formatCode position (bottom, center, insideEnd, insideBase, left, outsideEnd, right, top). Each chart type supports specific positions. showCategory showLegendKey showPercent showSeries showValue
serRgbColors	array	series colors
valueDataLabels	array	position (bottom, center, insideEnd, insideBase, left, outsideEnd, right, top). Each chart type supports specific positions. showCategory showLegendKey showPercent showSeries showValue
valueRgbColors	array	values colors
verticalAxis	array	textBold textDirection (horizontal, rotate90, rotate270) textItalic textSize textUnderline (DrawingML values such as none, sng, dash)

Return values

No data or type values.

ExternalXLSX values are not valid.

Exceptions

Method not available.

Code samples

Example #1

require_once 'classes/CreateDocx.php';

$docx = new CreateDocx();

$docx->addText('We will now add a 3D pie chart to the Word document:');

$data = array(
    'data' => array(
        array(
            'name' => 'Legend 1',
            'values' => array(20),
        ),
        array(
            'name' => 'Legend 2',
            'values' => array(30),
        ),
        array(
            'name' => 'Legend 3',
            'values' => array(40),
        ),
    ),
);

$paramsChart = array(
    'data' => $data,
    'type' => 'pie3DChart',
    'rotX' => 20,
    'rotY' => 20,
    'perspective' => 30,
    'color' => 2,
    'sizeX' => 10,
    'sizeY' => 5,
    'chartAlign' => 'center',
    'showPercent' => 1,
);
$docx->addChart($paramsChart);

$docx->addText('And now the same chart in 2D with a different color scheme and without the percentages:');

$data = array(
    'data' => array(
        array(
            'name' => 'Legend 1',
            'values' => array(20),
        ),
        array(
            'name' => 'Legend 2',
            'values' => array(30),
        ),
        array(
            'name' => 'Legend 3',
            'values' => array(40),
        ),
    ),
);

$paramsChart = array(
    'data' => $data,
    'type' => 'pieChart',
    'color' => 3,
    'sizeX' => 10,
    'sizeY' => 5,
    'chartAlign' => 'center',
);
$docx->addChart($paramsChart);

$docx->createDocx('output');

The resulting Word document looks like:

Example #2

require_once 'classes/CreateDocx.php';

$docx = new CreateDocx();

$docx->addText('We will now add a 3D horizontal bar chart to the Word document:');

$data = 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),
        ),
    ),
);
$paramsChart = array(
    'data' => $data,
    'type' => 'bar3DChart',
    'color' => '2',
    'perspective' => '20',
    'rotX' => '20',
    'rotY' => '20',
    'sizeX' => '15',
    'sizeY' => '10',
    'chartAlign' => 'center',
    'legendOverlay' => '0',
    'border' => '1',
    'hgrid' => '1',
    'vgrid' => '2'
);
$docx->addChart($paramsChart);

$docx->addText('And now the same chart in 2D with a different color scheme and with the table data:');

$data = 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),
        ),
    ),
);
$paramsChart = array(
    'data' => $data,
    'type' => 'barChart',
    'color' => 5,
    'sizeX' => 15,
    'sizeY' => 10,
    'chartAlign' => 'center',
    'legendPos' => 'none',
    'legendOverlay' => '0',
    'border' => '1',
    'hgrid' => '1',
    'vgrid' => '0',
    'showTable' => '1'
);
$docx->addChart($paramsChart);

$docx->createDocx('output');

The resulting Word document looks like:

Example #3

require_once 'classes/CreateDocx.php';

$docx = new CreateDocx();

$docx->addText('We will now add a 3D column chart "100% stacked" to the Word document:');

$data = 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),
        ),
    ),
);
$paramsChart = array(
    'data' => $data,
    'type' => 'col3DChart',
    'color' => '2',
    'perspective' => '40',
    'rotX' => '30',
    'rotY' => '30',
    'chartAlign' => 'center',
    'showtable' => 1,
    'sizeX' => '10',
    'sizeY' => '10',
    'legendPos' => 't',
    'legendOverlay' => '0',
    'border' => '1',
    'hgrid' => '0',
    'vgrid' => '0',
    'groupBar' => 'percentStacked'
);
$docx->addChart($paramsChart);

$docx->addText('And now the same chart with a different color scheme and perspective, without the data table and simply stacked:');

$data = 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),
        ),
    ),
);
$paramsChart = array(
    'data' => $data,
    'type' => 'col3DChart',
    'color' => '3',
    'perspective' => '10',
    'rotX' => '10',
    'rotY' => '10',
    'chartAlign' => 'center',
    'sizeX' => '10',
    'sizeY' => '10',
    'legendPos' => 'b',
    'legendOverlay' => '0',
    'border' => '1',
    'hgrid' => '3',
    'vgrid' => '0',
    'groupBar' => 'stacked'
);
$docx->addChart($paramsChart);

$docx->createDocx('output');

The resulting Word document looks like:

Example #4

require_once 'classes/CreateDocx.php';

$docx = new CreateDocx();

$docx->addText('Chart with custom colors:');

$data = 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),
        ),
    ),
);
$paramsChart = array(
    'data' => $data,
    'type' => 'colChart',
    'color' => '3',
    'perspective' => '10',
    'rotX' => '10',
    'rotY' => '10',
    'chartAlign' => 'center',
    'sizeX' => '10',
    'sizeY' => '10',
    'legendPos' => 'b',
    'legendOverlay' => '0',
    'border' => '1',
    'hgrid' => '3',
    'vgrid' => '0',
    'groupBar' => 'stacked',
    'theme' => array(
        'serRgbColors' => array(null, 'FF00FF', '00FFFF'),
        'valueRgbColors' => array(
            array('FF0000'),
            null,
            array(null, null, '00FF00'),
        ),
    ),
);
$docx->addChart($paramsChart);

$docx->createDocx('output');

The resulting Word document looks like: