<?php
namespace App\Exports;
use Generator;
use Maatwebsite\Excel\Concerns\FromGenerator;
use Maatwebsite\Excel\Concerns\WithCharts;
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;

class TestSeries implements WithCharts, FromGenerator
{
    public function generator(): Generator
    {
        yield ["label", "serie1", "serie2"];
        for ($i = 1; $i <= 5; $i  ) {
            yield ["test".$i, $i, $i 1];
        }
    }

    public function charts()
    {
        $label       = [new DataSeriesValues('String', 'Worksheet!$B$1', null, 1)];
        $label2      = [new DataSeriesValues('String', 'Worksheet!$C$1', null, 1)];
        $categories  = [new DataSeriesValues('String', 'Worksheet!$A$2:$A$5', null, 4)];
        $values      = [new DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', null, 4)];
        $values2     = [new DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', null, 4)];
        $series = new DataSeries(DataSeries::TYPE_LINECHART, DataSeries::GROUPING_STANDARD,
            range(0, \count($values) - 1), $label, $categories, $values);
        $series2 = new DataSeries(DataSeries::TYPE_LINECHART, DataSeries::GROUPING_STANDARD,
            range(0, \count($values2) - 1), $label2, $categories, $values2);
        /* works well with 1 one of the serie
        $plot   = new PlotArea(null, [$series]);
        $plot   = new PlotArea(null, [$series2]);
        */
        // but doesnt work with both
        $plot   = new PlotArea(null, [$series, $series2]);
        $legend = new Legend();
        $chart  = new Chart('chart name', new Title('chart title'), $legend, $plot);
        $chart->setTopLeftPosition('A12');
        $chart->setBottomRightPosition('N27');
        return $chart;
    }
}