How to change format of secondary axis

Aspose.Words Product Family
1

Hello,

I have a chart in word document with secondary axis. How do I change the formatcode in code? I’m able to change the format code of primary axis as below

var shape = (Shape)Document.Sections[(x].GetChild(NodeType.Shape, 0, true);
shape.Chart.AxisY.NumberFormat.FormatCode = "#,##0,,"

However shape.Chart.AxisZ (I’m assuming its secondary axis) is null.

Please advice.

2

@rhegde No, Chart.AxisZ is not the secondary axis. Secondary axis in MS Word charts are defined using combo charts, i.e. there are several charts in the single shape. Unfortunately, Aspose.Words does not provide public API to work with combo charts. This feature request is logged as WORDSNET-20209. We will keep you informed and let you know once it is implemented.

3

The issues you have found earlier (filed as WORDSNET-20209) have been fixed in this Aspose.Words for .NET 24.5 update also available on NuGet.