Re: Please Help! Change Axis labels using XSSFValueAxis or ValueAxis class
You will have to use the underlying CT* classes, there is no good way to do
it with the POI API directly. This is partly because Excel determines the
axis label from either a formula or static text, each stored as different
properties in the underlying XML, and mutually exclusive.
Your best option is to open a sample file in Excel, edit the title you want
to change, save it as a new file, then unzip both files and compare their
contents. This will show you where in the XML your new value is stored.
From that, you can deduce the CT object path you will need to use to set
When I get the axis title, I have to go from the chart axis object lists: