Add trendline in a chart with XlsIO

[Juan]

As I can add trendline on a chart made with XlsIO?

Thanks.

[Abirami Varadharajan]

Hi Juan, 

 

Thank you for contacting Syncfusion support. 

 

Yes, you can add trendline to the chart created using XlsIO. Kindly refer the below code snippet to achieve your requirement. 

 

Code Example: 

       chart.Series(0).TrendLines.Add(ExcelTrendLineType.Linear); 

 

We have also shared a sample for your reference, which can be downloaded from the following location. Kindly refer to this and let us know if it helps. 

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample1912343098.zip  

 

Regards, 

Abirami. 

[Juan]

Perfect!
Thank you so much for your help.

[Juan]

A question more ... How can I put color to the trendline?

Thanks.

[Abirami Varadharajan]

Hi Jaun, 

 

Thank you for updating us. 

 

Query	Details
How can I put color to the trendline?	Kindly refer the below code for formatting the trendline.    Code Example:          chart.Series(0).TrendLines(0).Border.LineColor = Color.Aquamarine          chart.Series(0).TrendLines(0).Border.LinePattern = ExcelChartLinePattern.Dash          chart.Series(0).TrendLines(0).Border.LineWeight = 3

 

Please let us know if you have any concerns. 

 

Regards, 

Abirami. 

[Juan]

Thank you very much for your quick response.

It has worked perfectly!

Thank you.

[Abirami Varadharajan]

Hi Juan, 

 

We are glad that your requirement is fulfilled. Please let us know if you need any further assistance. 

 

Regards, 

Abirami.