Create a Linear Trendline in Excel on a Chromebook
Question details
The user wants to add a linear trendline to an Excel scatter plot while working on a Chromebook.

- Product
- Excel for the web
- Device & OS
- Chromebook (ChromeOS)
- Scenario
- The user is editing a workbook and wants to visualize the linear relationship between two sets of values.
- Observed behavior
- Excel for the web may not offer a control to add a linear trendline to the scatter chart.
Check that your scatter plot uses numeric X and Y values and that the data ranges have the same number of entries. Select the chart in Excel for the web and check whether a trendline option is available before switching to another method.
Add a Linear Trendline in Desktop Excel
Use an installed version of Excel on a supported computer when the browser version does not provide trendline controls.
Open the workbook in an installed version of Excel on a supported Windows or Mac computer.
Click the scatter chart, then select the data series you want to analyze.
Choose Chart Design > Add Chart Element > Trendline > Linear. Alternatively, right-click the data series, select Add Trendline, and choose Linear.
Select File > Save to keep the chart changes in the workbook.

Calculate a Linear Regression in Excel for the Web
Use worksheet formulas to calculate the best-fit line when you cannot add a trendline in the browser.
Add a Linear Trendline with WPS Spreadsheet
Use WPS Spreadsheet on a supported desktop computer to open the workbook and add a linear trendline to a scatter chart. The desktop app is an alternative when the Chromebook browser does not offer the chart control.
- 1. Open the workbook: Install and open WPS Office on a supported desktop computer, then use File > Open to select the Excel workbook.
- 2. Select the chart: In WPS Spreadsheet, click the scatter chart and select the data series.
- 3. Add a trendline: Right-click the data series and choose Add Trendline, then select Linear. Menu labels may vary by version.
- 4. Save the changes: Select File > Save to keep the updated chart in the workbook.

Frequently Asked Questions
Can I add a trendline in Excel for the web on a Chromebook?
Trendline controls may not be available in Excel for the web. Select the chart and check its chart options; if Linear Trendline is unavailable, use desktop Excel or calculate the regression with SLOPE and INTERCEPT.
Where is the linear trendline option in desktop Excel?
Select the scatter chart and choose Chart Design > Add Chart Element > Trendline > Linear. You can also right-click a data series and choose Add Trendline.
How do I find the equation of the best-fit line with formulas?
Use =SLOPE(known_y_values,known_x_values) for the slope and =INTERCEPT(known_y_values,known_x_values) for the intercept. Substitute the results into y = mx + b.
Will the regression formulas automatically draw a trendline?
No. SLOPE and INTERCEPT calculate the line's coefficients. You can use them to calculate fitted Y values in worksheet cells, but adding a formatted trendline requires a chart feature that supports it.




