How to set the Interval unit in a chart?

Aspose.Cells Product Family
1

Hello,

I have a chart in my Excel file where the X axis is a set of dates. As I have many values, the axis labels are sometimes hardly legible (see 1-before.jpg).
In Excel 2007, I can change the “Interval Unit” (see 2-menu.jpg and 3-option.jpg) to 7 (for example), to make this chart more readable (see 4-after.jpg).

My question is how can I set this option using Aspose Cells (v2.5.4.1) ? I didn’t find anything in the chart.getCategoryAxis() object…

Thanks

2

Hi,

Thanks for your interest in Aspose.Cells for Java and the screenshots.

Can you please also attach the sample xls/xlsx file, which you can create manually using Ms-Excel, with such a chart? It will help us find the Aspose.Cells solution.

3

Hello,

Here is a simple exemple to illustrate my question.
I generate an XLSX file, using the following code:

Workbook workbook = new Workbook();
Worksheet ws = workbook.getWorksheets().getSheet(0);
Cells cells = ws.getCells();
for (int i = 1; i < 100; i++) {
cells.getCell(“A” + i).setValue(i);
cells.getCell(“B” + i).setValue(i);
}
Chart chart = ws.getCharts().addChart(ChartType.LINE, 5, 1, 20, 10);
chart.getNSeries().add(“A1:B99”, true);
workbook.save(“c:\test.xlsx”, FileFormatType.XLSX);

Please find the generated Excel sheet, as well as the modified one, with the adequate option filled.

Regards.

4

Hi,


Thanks for your sample files.
Please find below the source code to specify the interval unit for axis of a chart. Also, attached is my output file. I have tested this code with latest release of Aspose.Cells JAVA v2.5.4.

JAVA

Workbook wb = new Workbook();
wb.open(“C:\temp\generated.xlsx”);
Chart chart = wb.getWorksheets().getSheet(0).getCharts().getChart(0);
//Specify Axis Interval Unit
chart.getCategoryAxis().setTickLabelSpacing(10);
wb.save(“C:\temp\out.xlsx”);
5

Thanks, it answers my question!

Regards.