Free Support Forum - aspose.com

Dash type and cap type options for chart lines

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://apireference.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

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.

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.

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;