Category axis size

Aspose.Cells Product Family
21

@yvowell,
You may please give try to the following function to set the rotation angles and share the feedback.

charts.get(0).getCategoryAxis().getTickLabels().setRotationAngle(angle);
charts.get(1).getCategoryAxis().getTickLabels().setRotationAngle(angle);
22

@yvowell,
You should also use the following code to produce desired output file:

    charts.get(0).getPlotArea().setInnerWidth(3016);
    charts.get(0).getPlotArea().setInnerHeight(2757);
    charts.get(1).getPlotArea().setInnerWidth(3016);
    charts.get(1).getPlotArea().setInnerHeight(2757);

Let us know your feedback.

23

this works but causes the plot area to go over the title and if the axis labels are very long it still distorts the plot area size
can the size of horizontal axis are be controlled?

24

@yvowell,
We are looking into this requirement and will share our feedback soon.

25

@yvowell,

We evaluated your issue further.
I am afraid, the size of horizontal axis cannot be controlled directly. Its size will be changed with the size of plot area accordingly. However if the InnerHeight of PlotArea is set too large (e.g 3116 or longer in our test), the plot area will go over the title and the axis labels become very long.

26

Thank you guys very much! helped me a lot.

27

@yvowell,
Good to know that your issue is sorted. Feel free to contact us at any time if you need further help or have some other issue or queries, we will be happy to assist you soon.