Chart & Visualization Issues

Display a Linear Trendline Equation in Excel on an Android Tablet

Huma Ashraf ChHuma Ashraf Ch Nov 18, 2026 870 views

Question details

Find out whether Excel for Android can display a linear trendline equation directly on a chart.

Display a Linear Trendline Equation in Excel on an Android Tablet
Product
Microsoft Excel for Android
Device & OS
Android tablet
Scenario
The user wants to show the equation of a linear trendline on a chart, as in desktop Excel.
Observed behavior
Excel for Android has limited chart trendline options and may not offer a control to display the equation on the chart.
Before you start

Identify the cells containing your paired x- and y-values and check that they contain numeric data. If you need the equation as a chart label, check whether you have access to desktop Excel.

Solution 1Recommended

Display the equation on the chart in desktop Excel

Use desktop Excel when the equation must appear directly on the chart.

1
Open the workbook

Open the workbook containing your chart in desktop Excel.

2
Add a linear trendline

Select the chart's data series, right-click it, and choose Add Trendline. In the Format Trendline pane, select Linear.

3
Show the equation

In the Format Trendline pane, select Display Equation on chart. Save the workbook to keep the chart changes.

Display the equation on the chart in desktop Excel
Already have a trendline?: Right-click the existing trendline and choose Format Trendline to find the equation display option.
Free Microsoft Office alternative

Work with chart data in WPS Spreadsheets

WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Its Microsoft Excel format compatibility makes it easier to move existing workbooks into WPS, though it does not change Excel for Android's chart options.

Calculate linear trendline coefficients with spreadsheet formulasOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can Excel for Android display a trendline equation on a chart?

Excel for Android has limited trendline controls and may not provide an option to display the equation on the chart. If that option is unavailable, calculate the coefficients in cells or use desktop Excel to add the chart label.

Where is the equation option in desktop Excel?

Right-click the trendline, choose Format Trendline, and select Display Equation on chart in the pane.

Which formulas give me the slope and intercept?

Enter =SLOPE(y_values,x_values) for the slope and =INTERCEPT(y_values,x_values) for the intercept. Replace the placeholders with your worksheet ranges.

Will the formulas put the equation on my chart?

No. SLOPE and INTERCEPT return values in worksheet cells. To display the equation as a chart label, use the trendline equation option in desktop Excel.