Set the Y axis range in line chart

[berberon]

Is it possible in 1.29?

[oleibman]

I am not entirely sure what you have in mind, but you could try something like:

$axis->setAxisOption('minimum', $minimum);
$axis->setAxisOption('maximum', $maximum);

[berberon]

I tried to do something like

// Create the plot area with the data series
$plotArea = new PlotArea(null, [$series]);

// Create the chart
$chart = new Chart(
    'chart1',
    new Title($chartTitle),
    new Legend(Legend::POSITION_RIGHT),
    $plotArea
);

// Add Y-axis minimum and maximum settings
$axis = $chart->getYAxis();
$axis->setAxisOption('minimum', 20);
$axis->setAxisOption('maximum', 30);

and

// Create the plot area with the data series
$plotArea = new PlotArea(null, [$series]);

// Create the chart
$chart = new Chart(
    'chart1',
    new Title($chartTitle),
    new Legend(Legend::POSITION_RIGHT),
    $plotArea
);

// Add Y-axis minimum and maximum settings
$yAxis = $chart->getPlotArea()->getAxis()[1]; 
$yAxis->setAxisOption('minimum', 20);
$yAxis->setAxisOption('maximum', 30);

but i get
Call to undefined method PhpOffice\PhpSpreadsheet\Chart\Chart::getYAxis
and
Call to undefined method PhpOffice\PhpSpreadsheet\Chart\PlotArea::getAxis()

I do have use PhpOffice\PhpSpreadsheet\Chart\Axis;

[berberon]

never mind,

this works :

// Add Y-axis minimum and maximum settings
$yAxis = $chart->getChartAxisY();
$yAxis->setAxisOption('minimum', 20);
$yAxis->setAxisOption('maximum', 30);

thanks