Chart & Visualization Issues

Add a Regression Equation to an Excel Chart on iPad

Muhammad TalhaMuhammad Talha Nov 20, 2026 869 views

Question details

The user wants to add a regression equation to a scatter chart in Excel for iPad.

Add a Regression Equation to an Excel Chart on iPad
Product
Microsoft Excel for iPad
Device & OS
iPadOS
Scenario
The user is working with paired X and Y data and wants to show a regression equation on a chart.
Observed behavior
Excel for iPad does not provide the desktop option to add a trendline and display its equation directly on a scatter chart.
Before you start

Arrange your numeric X and Y values in two columns with matching rows. If you need the equation displayed on the chart, make sure you can open the workbook in desktop Excel.

Solution 1Recommended

Add the trendline equation in desktop Excel

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

1
Open the workbook

Open the workbook in Excel on a Windows PC or Mac and select the scatter chart.

2
Add a linear trendline

On the Chart Design tab, select Add Chart Element > Trendline > More Trendline Options, then choose Linear.

3
Show the equation

In the Format Trendline pane, check Display Equation on chart.

4
Save the workbook

Select File > Save, then reopen the workbook on your iPad. Chart display and editing options may vary in the mobile app.

Add the trendline equation in desktop Excel
Free Microsoft Office alternative

Work with spreadsheet data in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel workbooks and continue working with spreadsheet data when moving between office applications.

Work with spreadsheet data and charts in WPS SpreadsheetCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for easier migrationFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can I add a trendline equation directly in Excel for iPad?

Excel for iPad does not provide the desktop option to add a trendline and display its equation on a chart. Open the workbook in desktop Excel to add it.

How do I calculate the slope and intercept on an iPad?

Enter =SLOPE(y_range,x_range) in one cell and =INTERCEPT(y_range,x_range) in another, replacing the ranges with your paired data.

Where is the equation option in desktop Excel?

Select the scatter chart, then choose Chart Design > Add Chart Element > Trendline > More Trendline Options. Choose Linear and check Display Equation on chart.

Can I predict a Y value from an X value in Excel?

Yes. Enter =FORECAST.LINEAR(x,y_range,x_range) in a cell, replacing x with the value to predict and the ranges with your existing Y and X data.