Aspose chart Align axis x values to the left

Aspose.Cells Product Family
,
22

@John.He
I have attached the my current output Excel and Image file of the graph and highlighted the incorrect area with circle, also attached the expected Graph Image “ExpectedGraphImage.png”.
ExpectedGraphImage.png (77.0 KB)

CurrentOutputGraphImg.png (14.6 KB)

CurrentGraphXlsx.png (73.5 KB)

23

@jshelkme
Due to the discrepancy between your expected image “ExpectedGraphImage. png” and the other two images, I am still unable to distinguish your true needs.
Do you want to place the numbers on the left side of the short vertical line? Please refer to the image. result.jpg (84.6 KB)
If that’s the requirement, would you like to share an Excel file of the expected image? We will further investigate how to achieve this display.

Sorry for any inconvenience caused to you.

24

@jshelkme
We adjusted the position of the numbers by testing with the following example code. Please refer to the attachment. result.zip (36.4 KB)

The sample code as follows:

Workbook book = new Workbook(filePath + "POCAsposeOpenXMLoutput.xlsx");
Chart chart = book.Worksheets[0].Charts[0];
chart.CategoryAxis.TickLabels.AlignmentType = TickLabelAlignmentType.Center;
chart.CategoryAxis.AxisBetweenCategories = false;
book.Save(filePath + "POCAsposeOpenXMLoutput_result.xlsx");

chart.ToImage(filePath + "out_result.png");

After further research, we found that the position of Tick Marks cannot be adjusted, so the position of Tick Marks on the left side of a single bar in the image you provided cannot be achieved in Excel. If you still have questions, please provide your sample file. If you can take a screenshot and highlight how to set the position of Tick Marks, it will be very helpful for us to locate the issue and implement the requirements.