Add a Regression Equation to an Excel Chart on iPad
Question details
The user wants to add a regression equation to a scatter chart in Excel for 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.
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.
Add the trendline equation in desktop Excel
Use desktop Excel when the regression equation must appear directly on the scatter chart.
Open the workbook in Excel on a Windows PC or Mac and select the scatter chart.
On the Chart Design tab, select Add Chart Element > Trendline > More Trendline Options, then choose Linear.
In the Format Trendline pane, check Display Equation on chart.
Select File > Save, then reopen the workbook on your iPad. Chart display and editing options may vary in the mobile app.

Calculate the regression equation in worksheet cells
Use formulas on your iPad to calculate a linear regression equation when you cannot use desktop Excel.
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.

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.




