How to Add a Trendline in Excel

An Excel trendline adds a fitted line to a chart so readers can see the overall direction of the data. It is useful when individual points are noisy but the trend still matters: sales by week, monthly costs, customer inquiries, labor hours, or campaign results.

Use trendlines to clarify direction, not to pretend a simple chart is a full forecast.

Add a trendline to a chart

Step 1. Put dates or periods in one column and values in the next column.

Step 2. Select the data and insert a line chart or scatter chart.

Step 3. Click the chart.

Step 4. Choose Chart Design -> Add Chart Element -> Trendline.

Step 5. Start with Linear unless the data clearly needs another option.

Step 6. Format the line so it is visible but not louder than the actual data.

You can also right-click the data series and choose Add Trendline.

Example: review weekly sales movement

Suppose a restaurant tracks weekly sales for the last six months. Some weeks spike because of holidays, events, weather, or promotions. A trendline can show whether the general direction is improving, flat, or declining.

That chart is useful beside a sales pipeline template for restaurants or a small business budget for restaurants because it separates normal week-to-week noise from bigger revenue movement.

If the chart covers only a few weeks, avoid overreading it. Trendlines need enough history to mean something.

Pick the right trendline type

Linear works for a steady upward or downward direction. Moving average works when you want to smooth short-term volatility. Exponential only makes sense when the rate of change accelerates in a realistic way.

For most operating reviews, linear or moving average is enough.

Common trendline mistakes

The Griddy way

Trendlines are most useful after the workbook has clean dates, consistent periods, and comparable values.

"Add a trendline to this weekly sales chart and explain whether the last quarter is improving or just noisy"

Griddy can clean the date series, build the chart, and summarize the trend in plain language for a manager review.

Read a trendline carefully

A trendline describes the pattern in the selected observations; it does not prove that the relationship is causal or that the next period will follow it. Use a chart with an honest time or category axis, remove accidental blank rows, and confirm that the selected series is the one you intend to model. Treat the displayed R-squared value as a fit diagnostic, not as a forecast guarantee. If the data contains a structural break, seasonality, or outliers, show those points and explain the limitation instead of choosing a more complex trendline simply because it looks smoother.

Sources

• Microsoft Support: Add a trend or moving average line to a chart
• Microsoft Support: Available chart types in Office