phpoffice/spreadsheet how can I add in a chart a value to each column

Question

I am using PHPOffice/PhpSpreadsheet to produce a Chart in excel like this one:

But I can not set spreadsheet chart to display each column's value.

This is the code I have used:

   

$yaxis = new Axis();
$xaxis = new Axis();
$xaxis->setAxisOptionsProperties('low',          null,                              null,                       null,                       null,           null,               0,              700,            null,                   null);    
$yaxis->setAxisOptionsProperties('low',          null,                              null,                       null,                       null,           null,               -700,              700,            null,                   null);
                                //$axis_labels, $horizontal_crosses_value = null, $horizontal_crosses = null, $axis_orientation = null, $major_tmt = null, $minor_tmt = null, $minimum = null, $maximum = null, $major_unit = null, $minor_unit = null
$chart = new Chart(
    'chart1', // name
    $title, // title
    null, // legend
    $plotArea, // plotArea
    true, // plotVisibleOnly
    0, // displayBlanksAs
    null, // xAxisLabel
    $yAxisLabel,  // yAxisLabel
        $xaxis,
        $yaxis,
        null,
        null
);

$worksheet->addChart($chart);

Is it possible to do it with phpoffice/spreadsheet?

Answer 1

I've found the solution.

You have to setshowval in the layout of the plot area.

$layout1 = new Layout();
$layout1->setShowVal(true);

$plotArea = new PlotArea($layout1, [$series]);