Bar chart left alignment categoryAxis

Aspose.Total Product Family
1

I generate Bar chart I set categoryAxis.TickLabels.AlignmentType = TickLabelAlignmentType.Left; but this property not working.

Output chart image:
Output.png (11.6 KB)

Excepting Chart image:
ExceptingOutput.png (11.2 KB)

2

@sanjeevkumar.v
Can you provide code and source document if there any present so we could investigate this issue?

4

I attached zip file.

BarChart.zip (29.0 KB)

5

@sanjeevkumar.v
It seems that your code is done mostly with Aspose.Cells code, not with Aspose.Pdf
I’ll reassign this to according forum branch, my colleagues will help you shortly

7

Also, I need a small code help. How can I make the table border lines dashed?
Screenshot 2025-02-12 185714.png (77.4 KB)

8

@sanjeevkumar.v
Please check document https://docs.aspose.com/cells/net/cells-border-settings:

    // Creating a range of cells starting from "A1" cell to 3rd column in a row
    Range range = worksheet.Cells.CreateRange(0, 0, 1, 3);

    // Adding a thick top border with blue line

    range.SetOutlineBorders( CellBorderType.Dashed, Color.Blue);
9

@sanjeevkumar.v
Could you create an excepted chart in MS Excel and share the template file here? We will check it soon.

10

@simon.zhao
I think you misunderstand my question. I asking this table border style in Aspose.PDF Product Family aspose-pdf-net not a Aspose.Cells Product Family. but chart is Aspose.Cells Product Family cells-net

11

@sanjeevkumar.v
Could you create a template file with your excepted chart in MS Excel and share it here ?

12

I shared BarChart.zip file. what I expecting chart in image. can you check it.

13

@sanjeevkumar.v,

You only provided screenshots and not Excel file(s). In the screenshots you provided, there are differences in categories and formatting compared to your current output results. Please manually create the chart you want in MS Excel using your desired dataset (which should be available in a worksheet within the same workbook), save the Excel file, compress it into a zip file, and share it with us here. We will check and assist you on how to do it using Aspose.Cells APIs.

14

@sanjeevkumar.v,

I am moving the thread back to Aspose.Total forum where one of the colleagues from Aspose.PDF team will evaluate and assist you on it.
@ilyazhuykov FYI.

1 Like
16

@sanjeevkumar.v
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): PDFNET-59287

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

Currently I haven’t found any direct way to set dashed style for table’s border in Aspose.Pdf so I added task for development team. You’ll be notified when it will be resolved

17

Hi @ilyazhuykov
We have studied your requirements, and the setting of this attribute:
categoryAxis.TickLabels.AlignmentType = TickLabelAlignmentType.Left
It is corresponds to the attribute in the red circle in the figure below.
250214.png (20.8 KB)

You can try to change this property in excel, it is consistent with the effect after you set it with Aspose.Cells code.
But for the effect you expect in your screenshot, we seem to be unable to find a way to support it in Excel, and the current rendering effect Aspose.Cells is consistent with Excel.