Share via

excel scatterplot trendline equation on ipad

Anonymous
2018-01-12T17:02:36+00:00

I want to show my college class how to create an XY scatter plot on Excel, and to show the trendline together with the equation of the line, and R squared value. Our institution recently bought top of the line ipads for all students. Yet I cannot figure out how to get the equation of the line to show on the ipad.

Microsoft 365 and Office | Excel | For home | iOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-01-13T18:23:19+00:00

    Hi Richar, 

    Excel on iPad currently doesnt have the option to show the equation of trendline for a XT scatter plot. you can still plot a chart on a XY scatter chart and also display the trendline but we dont show the equation.

    Please put in a request for this feature on our uservoice site: https://aka.ms/iosxluservoice 

    Thanks,

    Sanjay

    Was this answer helpful?

    200+ people found this answer helpful.
    0 comments
  2. Anonymous
    2018-01-13T10:24:53+00:00

    Hi Richard,

    You can format the chart to show the R-squared value by enabling it from Chart Inspector. Follow the instructions below:

    1. Click the chart you’ve made.
    2. Click the Format sidebar (Paintbrush icon).
    3. Under Trendlines section, check the box beside Show R^2^Value.

    You might also want to review the following links for information about creating and modifying charts in Excel for iPad.

    Let us know if you need additional assistance.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments