.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

Trendline Interface

A trendline in a chart that shows trends in the series data.

Namespace: DevExpress.Spreadsheet.Charts

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll

Declaration

public interface Trendline :
    ShapeFormat,
    ShapeFormatBase

Remarks

The Trendline object is contained within the TrendlineCollection collection. The Series.Trendlines property provides access to a collection that contains all trendlines for a specified series.

The following code uses the TrendlineCollection.Add method to display a trendline of the ChartTrendlineType.Polynomial type. The Trendline object in the collection is customized as required.

Worksheet worksheet = workbook.Worksheets["chartTask3"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Create a chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.ScatterMarkers);
chart.SelectData(worksheet["C2:F3"], ChartDataDirection.Row);
chart.TopLeftCell = worksheet.Cells["H2"];
chart.BottomRightCell = worksheet.Cells["N14"];

// Set the minimum and maximum values for the chart value axis.
Axis axis = chart.PrimaryAxes[1];
axis.Scaling.AutoMax = false;
axis.Scaling.AutoMin = false;
axis.Scaling.Min = 0.6;
axis.Scaling.Max = 1.0;
chart.PrimaryAxes[1].MajorGridlines.Visible = false;

// Display a polynomial trendline.
chart.Series[0].Trendlines.Add(ChartTrendlineType.Polynomial);

// Customize the trendline.
Trendline tline = chart.Series[0].Trendlines[0];
tline.DisplayEquation = true;
tline.CustomName = "Trend";
tline.DisplayRSquare = true;
tline.Backward = 1;
tline.Forward = 2;
tline.Outline.SetSolidFill(Color.Red);

The resulting chart is shown in the following picture.

Trendline - customization

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Trendline interface.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also