PHPExcel图表轴选项设置为最小值 [英] PHPExcel Chart Axis Options set Minimum

问题描述

我在使用PHPExcel时遇到问题，这不是PHPExcel的错.在图形中，显示的值非常大，因此，由于最小值"的轴选项的默认设置为自动"，因此Excel决定为Y轴使用最小值156,000.通过进入轴格式"选项并将该轴的最小值设置为固定值0，可以在Excel中修复"该问题.

I'm having an issue with PHPExcel that it is not PHPExcel's fault. In a graph, the values being presented are very large, so since the default setting for the axis options for Minimum is Automatic, Excel is deciding to use a minimum value for the Y axis of 156,000. The issue can be "Fixed" in Excel by going into the Axis format option and setting a Fixed value of 0 for the minimum of that axis.

因此，我一直在尝试确定您是否可以从PHPExcel中设置此选项，但无法确定是否可能.

So I've been trying to figure out if you can set this option from within PHPExcel, but can't figure out if it's even possible.

那么您可以在PHPExcel中更改图表轴"格式选项吗?如果可以，怎么办?

So can you change the Chart Axis format options from within PHPExcel, and if so... how?

谢谢

推荐答案

此选项在PHPExcel中尚不可用

It's an option that isn't yet available with PHPExcel

这篇关于PHPExcel图表轴选项设置为最小值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！