Category axis value alignment

[vijayaa]

Hi Team,

Could you please tell how to align the category axis values to the center of corresponding bars.

Here by i attached the sample excel file for your reference.(I have created this excel file in java using aspose jar)

Thanks & Regards,

Vijayaa

[Amjad_Sahi]

Hi,

Thanks for the template file.

Please try DataLabels.setPosition attribute to accomplish your task. I have tested using the following sample code with your template file and it works fine.

e.g

Sample code:

Workbook workbook = new Workbook(String.valueOf(“sample.xlsx”));

// Get chart worksheet

Worksheet sheet = workbook.getWorksheets().get(“Chart”);

Chart chart = sheet.getCharts().get(0);

DataLabels datalabels;

for (int i = 0; i < chart.getNSeries().getCount(); i++) {

datalabels = chart.getNSeries().get(i).getDataLabels();

// Set the position of DataLabels

datalabels.setPosition(LabelPositionType.CENTER);

}

workbook.save(“out1.xlsx”);

Let us know if you still have any issue.

Thank you.

[vijayaa]

Hi,

Thanks for your response.

One more request is how we could align the category axis tick label to the center of the bar.

I have attached the screenshot for your reference.

Thanks & Regards,

Vijayaa

[Amjad_Sahi]

Hi,

How could you do this in MS Excel? I think this is not possible. If you still think this is possible, kindly do align the tick labels to the center of the bar in MS Excel manually, re-save the file and post us here, we will check how to do it via Aspose.Cells APIs.

Thank you.