Get Equation Text of Chart Trendline with C++

You can retrieve the equation text of a chart trendline using Aspose.Cells. Aspose.Cells provides the Trendline.GetText() property, which returns the equation text of a chart trendline. To make use of this property, you must first call the Chart.Calculate() method.

The following screenshot shows a chart with a trendline, and its equation text is displayed in red. We will retrieve this text using the Trendline.GetText() property in the following sample code.

C++ code to get equation text of chart trendline

#include <iostream>
#include "Aspose.Cells.h"

using namespace Aspose::Cells;
using namespace Aspose::Cells::Charts;

int main()
{
    Aspose::Cells::Startup();

    // Source directory path
    U16String srcDir(u"..\\Data\\01_SourceDirectory\\");

    // Create workbook object from source Excel file
    Workbook workbook(srcDir + u"source.xlsx");

    // Access the first worksheet
    Worksheet worksheet = workbook.GetWorksheets().Get(0);

    // Access the first chart inside the worksheet
    Chart chart = worksheet.GetCharts().Get(0);

    // Calculate the chart first to get the equation text of the trendline
    chart.Calculate();

    // Access the trendline
    Trendline trendLine = chart.GetNSeries().Get(0).GetTrendLines().Get(0);

    // Read the equation text of the trendline
    std::cout << "Equation Text: " << trendLine.GetDataLabels().GetText().ToUtf8() << std::endl;

    Aspose::Cells::Cleanup();
}

Output generated by the sample code

This is the console output of the above sample code.

Equation Text: y = 8.1333x + 5