Chart & Visualization Issues

How to Fix Excel Not Changing Linear Trendline to Polynomial

John WilsonJohn Wilson Nov 10, 2026 870 views

Question details

The user is unable to change an existing linear trendline to a polynomial trendline in an Excel chart.

How to Fix Excel Not Changing Linear Trendline to Polynomial
Product
Microsoft Excel
Device & OS
not provided
Scenario
Modifying a chart's trendline configuration to better fit non-linear numerical data.
Observed behavior
Excel retains the linear trendline instead of applying the polynomial curve, typically due to straight data, incorrect chart types, or non-numeric source values.
Before you start

Ensure that your chart is set to an XY Scatter chart, as standard line charts treat X-axis values as categorical text, which prevents polynomial trendlines from calculating correctly.

Solution 1Recommended

Change Chart Type to XY Scatter and Reapply Trendline

Converting the chart type to XY Scatter ensures numeric X-values are recognized properly, allowing polynomial trendlines to render accurately.

Excel requires purely numerical data on both axes to plot complex trendlines like polynomial curves. If you are using a standard Line chart, Excel treats the X-axis as text labels, forcing the trendline to remain linear or fail to display.

1
Select Chart Design

Click on your existing chart to select it, then navigate to the 'Chart Design' tab on the top ribbon.

2
Change Chart Type

Click 'Change Chart Type' and choose 'X Y (Scatter)' from the list of available chart categories.

3
Format Data Source

Verify that both your X and Y source data columns contain purely numeric values and are not formatted as text.

4
Format Trendline

Right-click the data series on the chart and select 'Format Trendline' to open the formatting pane.

5
Select Polynomial Order

Choose the 'Polynomial' option and set the 'Order' to 2 or 3, depending on the fluctuations in your data curve.

Change Chart Type to XY Scatter and Reapply Trendline
Data linearity: If your source data points form a nearly perfect straight line, even a polynomial trendline of order 2 or higher will visually appear as a straight linear line.

Easily Add Polynomial Trendlines in WPS Spreadsheet

WPS Spreadsheet provides intuitive charting tools that automatically detect numeric data, making it easy to add and format polynomial trendlines accurately without chart type conflicts.

  1. 1. Insert a Scatter Chart: Highlight your numeric dataset in WPS Spreadsheet, go to the 'Insert' tab, and select 'Scatter' chart.
  2. 2. Add a Trendline: Click on the generated chart, click the 'Chart Elements' shortcut button, and check the box for 'Trendline'.
  3. 3. Configure Polynomial Settings: Click 'More Options' next to Trendline, and select 'Polynomial' from the right-side properties panel.
Seamless compatibility with Microsoft Excel (.xlsx) formatsIntuitive chart formatting panel for advanced trendlinesFree and lightweight alternative to Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Why does my polynomial trendline look exactly like a linear one?

If your plotted data points are nearly perfectly straight, the calculated polynomial equation will have very small coefficients for the higher-order terms, resulting in a curve that appears completely linear.

Can I add a polynomial trendline to a standard Line chart?

It is not recommended. Standard Line charts treat the X-axis as categorical labels rather than continuous numeric values. You should change the chart type to an XY Scatter chart to properly calculate a polynomial trendline.

What does the 'Order' mean in a polynomial trendline?

The 'Order' determines the highest exponent in the polynomial equation (e.g., Order 2 is a quadratic equation with one curve, Order 3 is cubic with two curves). Higher orders allow the trendline to flex more to fit fluctuating data, up to an order of 6.

How can I check if my numbers are formatted as text?

Numbers formatted as text often align to the left side of the cell by default. You can highlight the cells, right-click, select 'Format Cells', and ensure the category is set to 'Number' or 'General'.