How to Add a Trendline in Excel
Add a trendline in Excel to show direction, seasonality, and movement in sales, costs, forecasts, and operational data over time.
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
| Mistake | Why it hurts | Better choice |
|---|---|---|
| Using too few data points | Trend is unstable | Use more periods before drawing conclusions |
| Forecasting too far forward | Chart implies false precision | Keep forecasts short and labeled |
| Hiding actual data | Reader only sees the model | Keep points or the original line visible |
| Mixing non-time categories | Trendline becomes misleading | Use time or numeric x-axis data |
NOTE
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.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.
Use this on real templates
Add direction to sales and budget review
Trendlines are useful when weekly or monthly operating data is noisy but the direction still matters for revenue and planning decisions.
Sales Pipeline Template for Restaurants
Track restaurant catering deals, events, wholesale opportunities, partnerships, values, stages, and next actions in one pipeline sheet.
Open templateFinanceSmall Business Budget for Restaurants
Plan restaurant sales, food costs, labor, rent, supplies, delivery fees, and operating margin in one free budget spreadsheet template.
Open templateSalesSales Pipeline
Track deals by stage, owner, value, and next move in one lightweight pipeline sheet. Keep close dates, weighted forecast, and rep follow-ups visible without needing a full CRM.
Open templateFinanceSmall Business Budget
Plan revenue, direct costs, overhead, and EBITDA in one compact operating budget. Keep H1 totals, margin, and owner notes visible without building a giant finance model.
Open template