研究代码后我发现它是possible反转轴:
$yAxis = new \PHPExcel_Chart_Axis();
$yAxis->setsetAxisOptionsProperties(
\PHPExcel_Chart_Axis::AXIS_LABELS_NEXT_TO,
null,
null,
\PHPExcel_Properties::ORIENTATION_REVERSED
);
$chart = new \PHPExcel_Chart(
"Chart1",
$titile,
$legend,
$plotArea,
true,
'0',
null,
null,
null, //xAxis parameter if you want to reverse the x axis
$yAxis
);
NOTE:如果将系列方向设置为列而不是条形
$series = new \PHPExcel_Chart_DataSeries(....);
$series->setPlotDirection(\PHPExcel_Chart_DataSeries::DIRECTION_COL);
轴是反向的,因此您为 Y 轴设置的选项将应用于 X 轴,反之亦然。
然而反转轴cannot通过其他预期有效的方法来实现:
$chart->getChartAxisY()->setAxisOrientation(\PHPExcel_Properties::ORIENTATION_REVERSED);
or
$yAxis = new \PHPExcel_Chart_Axis();
$yAxis->setAxisOrientation(\PHPExcel_Properties::ORIENTATION_REVERSED);
$chart = new \PHPExcel_Chart(
"Chart1",
$titile,
$legend,
$plotArea,
true,
'0',
null,
null,
null, //xAxis parameter if you want to reverse the x axis
$yAxis
);