Practical phpxlsx

Charts

Introduction

Working with charts is as easy as with pictures. You just need to choose the chart type to insert and add the values and legends.

There are 2D and 3D graphic available with many formats: bar, col, doughnut, line, pie...

Premium licenses include additional options to assign sophisticated styles such as defining custom and individual colors for series and values, adding color backgrounds and applying styles to axes.

Adding charts

For adding charts in the active sheet, call addChart:

public function addChart($chart, $position, $options)

This method includes the following parameters:

$chart: chart type (bar, bar3D, col, col3D, doughnut, line, line3D, pie, pie3D...)
$position: cell position in the active sheet (A1, C3, AB7...)
$options: array to set values, legends, settings...

For example, to add a pie chart:

// contents to be used as legends
$xlsx->addCell(array('text' => 'legend 1'), 'A3');
$xlsx->addCell(array('text' => 'legend 2'), 'B3');
$xlsx->addCell(array('text' => 'legend 3'), 'C3');
$xlsx->addCell(array('text' => 'legend 4'), 'D3');

// contents to be used as values
$xlsx->addCell(array('text' => 10), 'A4');
$xlsx->addCell(array('text' => 20), 'B4');
$xlsx->addCell(array('text' => 50), 'C4');
$xlsx->addCell(array('text' => 25), 'D4');

$chartData = array(
    'legends' => array('A3', 'B3', 'C3', 'D3'),
    'values' => array('A4', 'B4', 'C4', 'D4'),
);

$optionsChart = array(
    'data' => $chartData,
);
$xlsx->addChart('pie', 'H7', $optionsChart);

Legends, labels and values used to generate the chart must exist in the XLSX. In this sample, the addCell method inserts those values, but other methods and existing contents in templates can also be called.

Individual cell positions and cell range positions can be used to add legends, labels and values to charts. The following code uses cell ranges to add chart data:

// contents to be used as legends
$legends = array(
    array('legend 1', 'legend 2', 'legend 3', 'legend 4'),
);
$xlsx->addCellRange($legends, 'A3');

// contents to be used as values
$values = array(
    array(10, 20, 50, 25),
);
$xlsx->addCellRange($values, 'A4');

$chartData = array(
    'legends' => array('A3:D3'),
    'values' => array('A4:D4'),
);

$optionsChart = array(
    'data' => $chartData,
);

Tips and tricks

The 'color' option of the addChart method sets a color scheme included in Excel.

Premium licenses include a theme option to assign more advanced styles such as defining custom and individual colors for series and values, adding color backgrounds and applying styles to axes.

Next - HTML and CSS