Chart Axis - Display unit (Thousands, Millions) #3833
Labels
Comments
oleibman
added a commit
to oleibman/PhpSpreadsheet
that referenced
this issue
Dec 20, 2023
Fix PHPOffice#3833. Among the options for chart axes in Excel are the ability to show labels as multiples of specific powers of 10, with or without an explanatory label. The Excel spec seems to indicate that that you can customize the multiples to other values, but I don't see how to do that in Excel, so that can be a project for another day if someone figures out how. The label title can also be styled; that is not part of this PR, but I will look into it in future. For now, this PR supports the use of multiples with or without labels. The axes can also be displayed on a logarithmic scale (any base between 2 and 1000). This PR supports that.
11 tasks
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Discussed in #3656
Originally posted by Matteo-pd July 28, 2023
I have an Excel Chart with large values like 300,000.0
In Excel, I have the Axis Display Unit set to "Millions", so my Axis Label has values like 0.1; 0.2; 0.3; ...
How can I read the Axis Display Unit (None, Thousands, Millions, etc.)?
The text was updated successfully, but these errors were encountered: