No—Excel does not add one trendline that automatically fits every chart series together. In Microsoft 365 for Windows, add a trendline to each series separately; to fit one model to observations from all series, first combine those observations into a single chart series or create an aggregate series, then add a trendline to that series.
What a trendline applies to in Excel
A chart series is one set of related plotted values, such as sales for one product or monthly temperatures at one location. Excel attaches a trendline to a selected series, not to the chart as a whole. If a chart contains four series and you add a trendline to each one, Excel fits four separate lines or curves. It does not pool the underlying values into a fifth, chart-wide fit.
This distinction matters because the trendlines answer different questions. Separate fits show how each group changes. A pooled fit asks whether there is an overall relationship when observations from all groups are considered together. An aggregate fit asks how a summary, such as the monthly average across groups, changes. Those summaries can look similar, but they are not statistically interchangeable.
Add a trendline to each series
To give every series its own trendline in Excel for Microsoft 365 on Windows, repeat the operation for each series:
- Select the chart, then click a data point in the first series. Clicking once selects the series; check that the whole series is selected rather than just one point.
- Right-click the selected series and choose Add Trendline. Alternatively, select the chart and use Chart Design > Add Chart Element > Trendline > More Trendline Options.
- Choose a trendline type in the Format Trendline pane. Repeat for each other series that needs a fit.
- Optionally select Display Equation on chart or Display R-squared value on chart in the pane.
The exact right-click menu depends on what is selected. If Add Trendline does not appear, click a plotted point belonging to the intended series, not the chart area, legend, or axis. You can also use the Current Selection controls on the chart-formatting ribbon to select a named series before opening the trendline options.
In Excel for Mac, select the data series and use the chart’s Add Chart Element or contextual chart controls to add a trendline; ribbon placement and pane layout can differ from Windows. Excel for the web has fewer chart-editing controls than the desktop app, so open the workbook in desktop Excel if the required trendline options are unavailable.
Fit one trendline to observations from all series
To create one pooled trendline, build a helper table that places all the x-values and y-values into one pair of columns. Then add that pair as a single series in an XY (Scatter) chart and add a trendline to it. For instance, suppose a worksheet has months in column A and sales for three products in columns B, C, and D. A pooled helper table would repeat each month once for each product and place the corresponding sales beside it. The chart then has one series containing all product-month observations.
For a scatter chart, each observation needs an x-value and a y-value. If the original series share the same months, repeat the month value for each product’s observation. If the series have different dates or measurement values, use the appropriate x-value for each row rather than assuming that row position means the same thing in every series. A single scatter series can then fit one line or curve across the complete set of pairs.
Be clear about what the pooled result means. It gives each plotted observation equal weight in the fit. If one group has many more observations than another, it will contribute more points. If the groups have very different baselines or behaviors, a pooled line can conceal those differences; it does not prove that the same pattern applies within every group. Keep the individual series visible, or compare their separate fits, when group-level differences are important.
Choose between pooled data and an aggregate series
Combining every observation is not the same as calculating one value per date. Say three stores report weekly sales. A pooled fit uses all store-week values as separate points. An aggregate fit might use the average or total sales across the three stores for each week, producing one value per week. The first describes the relationship across all recorded store observations; the second describes the movement of the chosen summary over time.
Choose the method that matches the question:
- Use separate trendlines when you want to compare how each product, store, or location changes.
- Use a pooled series when you want one fit through all individual observations and those observations are reasonably comparable.
- Use an aggregate series when the business question concerns a total, average, or other summary at each time point.
- Use a weighted analysis outside the basic chart trendline feature if observations should contribute different weights. Excel’s chart trendline does not provide a setting to assign a weight to each point.
An average can hide variation: two groups might move in opposite directions while their average stays flat. Conversely, a pooled relationship can be driven by differences between groups rather than the pattern within each group. When those distinctions matter, show the data by group and consider a statistical method that accounts for group membership rather than relying on one chart trendline.
Use the chart type and x-values that fit the data
An XY (Scatter) chart is usually the clearest choice when x-values are numeric measurements, elapsed time, or dates with meaningful gaps. Scatter charts position points according to their actual x-values. A line chart is often suitable for a sequence of categories, such as named stages or evenly spaced reporting periods, but its horizontal axis is generally organized as categories. If dates are irregularly spaced, a line chart can make the spacing look uniform; a scatter chart with actual date values better reflects the intervals.
Excel trendlines are available for many common two-dimensional charts, including scatter, line, and column charts, but not every chart type supports them. Trendlines are not available for chart types such as pie, doughnut, radar, surface, 3-D, and stacked charts. If the command is missing, changing to a supported, unstacked two-dimensional chart may resolve the issue. A chart’s appearance is not enough to establish that it is suitable: the x-values must also represent the relationship you intend to model.
Select an appropriate trendline type
Excel offers several trendline models. A linear trendline fits a straight-line relationship and is a sensible starting point when a roughly constant increase or decrease is plausible. An exponential trendline models growth or decline at a changing absolute rate, while a logarithmic trendline can describe data that changes rapidly and then levels off. A polynomial trendline can bend to follow a curved pattern, and a power trendline describes a power relationship. A moving average smooths fluctuations over a chosen number of points rather than fitting the same kind of equation as the other options.
Do not choose a more complicated curve just because it hugs the plotted points more closely. A high-degree polynomial may follow noise and behave poorly beyond the observed range. Some model types also require suitable data: exponential fits require positive y-values, and logarithmic and power fits have restrictions on the values they can use. If a model cannot be selected or produces no result, check the series’ x- and y-values for zeros, negatives, blanks, or text values, as applicable.
For a moving average, the period controls how many points are used in each local average. A shorter period responds more quickly but leaves more variation visible; a longer period smooths more but can obscure short-term changes. Because this is a smoothing line, do not interpret it as a fitted equation that can be extended in the same way as a linear trendline.
Read the equation and R-squared carefully
When you display an equation, Excel writes the fitted relationship on the chart. For a linear fit, the equation has the form y = mx + b: m is the slope and b is the intercept. The meaning of x depends on the chart’s x-values. In a scatter chart using dates, x may be stored as Excel date serial numbers, so the displayed intercept may not be meaningful as a calendar date. Formatting the equation or using an appropriate time variable can make interpretation clearer.
R-squared describes how closely the fitted model accounts for variation in the data used for that fit. It is not a guarantee that the model is appropriate, that the relationship is causal, or that predictions outside the observed range will be reliable. A high value can result from a strong pattern, but it can also be misleading when data are grouped, the model is overly flexible, or important variables are omitted. Compare the plotted points, model assumptions, and practical context rather than selecting a model solely by the largest displayed R-squared.
For a chart with separate series, the displayed equation and R-squared belong to the particular trendline and series they accompany. They are not overall statistics for all the chart’s series. If you create a pooled helper series, the statistics describe that pooled set instead.
Common problems and practical checks
If the trendline appears only on one group, that is expected: Excel adds it to the selected series. Add one to each remaining series, or create a combined helper series for one pooled fit. If the line seems to use the wrong dates or spacing, check whether the chart uses category positions or numeric x-values, and consider an XY scatter chart. If a trendline does not appear, confirm that the chart type supports one and that a data series, rather than a chart element, is selected.
Before relying on the result, check the source data and chart setup:
- Confirm that each y-value is paired with the correct x-value, especially after reshaping data into a helper table.
- Check for blanks, text values, hidden rows, and accidental totals that could change which points are plotted.
- Verify that every series uses compatible units and comparable definitions before pooling them.
- Use the same trendline type for side-by-side comparisons unless there is a sound reason to compare different models.
- Label a pooled or averaged line clearly so readers do not mistake it for a trendline belonging to one original group.
A trendline is a chart analysis tool, not a substitute for checking the data. If you need a formal regression with confidence intervals, multiple predictors, or observation weights, use an appropriate statistical analysis tool rather than treating the chart’s line as a complete statistical report.
Frequently Asked Questions
Can I add one trendline to all series at once?
No. Excel applies each trendline to one selected series. Add separate trendlines one by one, or create a single helper series that contains the observations you want one trendline to fit.
Why does Excel show different trendlines for each series?
Each trendline is calculated from the points in its own series. Different groups can have different slopes, intercepts, or patterns, so their fits need not match.
Can one trendline include every point from several series?
Yes, if you first combine the x-y pairs into one series, typically in a helper table and an XY scatter chart. Excel will then fit the trendline to that combined series.
Is the average of several trendlines the same as a pooled trendline?
No. Averaging fitted lines is not generally equivalent to fitting one line to all the original observations. An aggregate series, a pooled series, and an average of separate fits answer different questions.
Can I use a trendline on a stacked chart?
Excel does not support trendlines on stacked chart types. Switch to a supported unstacked two-dimensional chart, such as a scatter chart when the x-values are numeric, if a trendline is needed.
Related
- Conditional Formatting Excel Whole Row: A Practical Guide
- Excel Conditional Formatting: Highlight Entire Rows
- Excel Conditional Formatting for Values Less Than a Cell
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Smooth Line Chart: How to Create and Format OneTo create a smooth line chart in Excel for Microsoft 365 on Windows, select your data, choose Insert…
- Excel Histogram by Date: Group Time into Useful BinsTo make an Excel histogram by date, select a column of real Excel dates, then choose Insert >…
- Excel Waterfall Chart End Value: Set the Final TotalTo make the last bar in an Excel waterfall chart show the ending balance, right-click that bar and…
- Excel Line Chart: How to Connect GapsTo connect gaps in an Excel line chart, select the chart and choose Chart Design > Select Data…
- Excel Gantt Chart Template With DependenciesYes. You can make an Excel Gantt chart template with dependencies by keeping tasks, durations, predecessor IDs, and…
- Excel Chart: Remove Dates With No Data From the AxisTo remove dates with no data from an Excel chart, select the horizontal axis, open Format Axis, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.