TrendLines in Chart

Aspose.Cells Product Family
1

Hi,

I am using trendlines in the chart. I am able to use the trendlines by adding them in series.

But when i trying to hiding the R-Value and Equations from chart. It is not hiding in the generated chart. I am using below code.

Series s = chart.Series[0];

s.TrendLines.Add(TrendlineType.Linear);

s.TrendLines[0].DisplayRSquared = false;

s.TrendLines[0].DisplayEquation = false;

Please let me know how can i hide the equations in the output chart.

Thanks,

Amit

2

Hi,

Thanks for the solution. But it is not working for me.

I am attaching sample application and input and output excel sheet.

Please let me know how i can fix the issue.

Thanks,

Amit

3

Hi,

Thanks for your posting and using Aspose.Cells.

We have tested this issue with your source file using the following code and found that Equation and RSquared are not hiding. So it is a bug of Aspose.Cells. We have logged this issue in our database. We will look into it and fix this issue. Once, the issue is fixed or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42017.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\ExcelChartTrendLine.xlsx”;


Workbook workbook = new Workbook(filePath);


Worksheet worksheet = workbook.Worksheets[0];


Chart chart = worksheet.Charts[0];


//The following lines are not hiding Equation and RSquared in trendline

chart.NSeries[0].TrendLines[0].DisplayEquation = false;

chart.NSeries[0].TrendLines[0].DisplayRSquared = false;


workbook.Save(filePath + “.out.xlsx”);

4

Hi,


Please download and try our latest version/fix : Aspose.Cells for .NET v7.5.3.4


We have fixed your issue now.


Thank you.


5

The issues you have found earlier (filed as CELLSNET-42017) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.