Dash type and cap type options for chart lines

Aspose.Cells Product Family
1

Please see the attached document.


In the chart, both lines are Dots, but the top series has Dash type “Square Dot” and Cap type “Square”.

I don’t see these options available using the Aspose.Cells.Drawing.Line object (https://reference.aspose.com/cells/net/aspose.cells.drawing/line), which so far as I can see, is the only choice available for formatting chart lines.

Can you tell me if there is a way to set the dash type and cap type in charts?

Thanks.
Shaun

2

Hi,


Thanks for the template file and details.

I have checked your issue a bit. It looks like some dash types e.g Square Dot and cap types are not available in the current APIs set.

I have logged a ticket with an id “CELLSNET-41660” for your desired options, we will look into it and get back to you soon.

Thank you.
3

Hi,

Please download and try this fix/version: Aspose.Cells for .NET (Latest Version) and let us know your feedback.

We have added some more properties for setting line style.

Thank you.

4

Hi,

And, see the sample lines of code for your reference:

Series aseries;
aseries = chart.NSeries[0];
Line line = aseries.Border;
line.DashType = MsoLineDashStyle.DashDot;
line.CapType = LineCapType.Square;