Display a Linear Trendline Equation in Excel on an Android Tablet
Question details
Find out whether Excel for Android can display a linear trendline equation directly on a chart.

- 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.
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.
Display the equation on the chart in desktop Excel
Use desktop Excel when the equation must appear directly on the chart.
Open the workbook containing your chart in desktop Excel.
Select the chart's data series, right-click it, and choose Add Trendline. In the Format Trendline pane, select Linear.
In the Format Trendline pane, select Display Equation on chart. Save the workbook to keep the chart changes.

Calculate the trendline equation in Excel for Android
Use worksheet formulas to find the linear equation when the chart-label option is unavailable.
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.

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.




