Category axis value alignment

Aspose.Cells Product Family
1
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
2

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.
3

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
4

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.