Alternate row labels for bar chart not visible in Java

Aspose.Cells Product Family
1

I am trying to create a bar chart with about 70 rows in the table using addChart API.

using aspose.cells for Java version 2.5.1 ( a bit old).
While the bars show up correctly, the alternate row labels are missing from the generated chart. i tried resizing it manually chart area in the exported excel but still it does not come.
Please refer attached xls export output.

w_chart = a_chartWorkSheet.getCharts().addChart(16,3,1,18, 13);

However, if i change the last param to 20, the row labels show correctly.

Further, if i change it to either 19 or 21, it does not show up again.

really weird…

please help.
2

Hi,


Please set the category’s Axis Tick Labels spacing to 1. This should solve your issue.

//Set teh TickLabel spacing
chart.getCategoryAxis().setTickLabelSpacing(1);


3

thanks a lot.

it worked fine.

4

Hi,

Thanks for your feedback.

We are glad to know your issue is resolved now.

If you still face any other issue, please free to post on our forum, we will help you asap.