Spreadsheets, driven by code.

<?php

require 'vendor/autoload.php';

use \PhpOffice\PhpSpreadsheet\Spreadsheet;
use \PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use \PhpOffice\PhpSpreadsheet\Chart\Chart;
use \PhpOffice\PhpSpreadsheet\Chart\DataSeries;
use \PhpOffice\PhpSpreadsheet\Chart\DataSeriesValues;
use \PhpOffice\PhpSpreadsheet\Chart\Legend;
use \PhpOffice\PhpSpreadsheet\Chart\PlotArea;
use \PhpOffice\PhpSpreadsheet\Chart\Title;

$spreadsheet = new Spreadsheet();
$worksheet = $spreadsheet->getActiveSheet();
$worksheet->setTitle('Sales');

// The data the chart plots.
$worksheet->fromArray([
    ['Month', 'Sales'],
    ['Jan', 120],
    ['Feb', 145],
    ['Mar', 98],
    ['Apr', 172],
]);

// The category axis — the Month labels.
$categories = [
    new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_STRING, 'Sales!$A$2:$A$5', null, 4),
];

// The values to plot — the Sales numbers.
$values = [
    new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_NUMBER, 'Sales!$B$2:$B$5', null, 4),
];

// The series name — the "Sales" header in B1.
$labels = [
    new DataSeriesValues(DataSeriesValues::DATASERIES_TYPE_STRING, 'Sales!$B$1', null, 1),
];

// A bar chart, drawn as vertical columns.
$series = new DataSeries(
    DataSeries::TYPE_BARCHART,
    DataSeries::GROUPING_CLUSTERED,
    range(0, count($values) - 1),
    $labels,
    $categories,
    $values
);
$series->setPlotDirection(DataSeries::DIRECTION_COL);

$plotArea = new PlotArea(null, [$series]);
$legend = new Legend(Legend::POSITION_RIGHT, null, false);
$title = new Title('Monthly Sales');

$chart = new Chart('sales-chart', $title, $legend, $plotArea);

// Anchor the chart onto the worksheet.
$chart->setTopLeftPosition('D2');
$chart->setBottomRightPosition('J17');
$worksheet->addChart($chart);

// The writer only emits charts when told to.
$writer = new Xlsx($spreadsheet);
$writer->setIncludeCharts(true);
$writer->save('chart.xlsx');

echo "Done. Wrote chart.xlsx with a column chart.\n";