Add a Trendline to an Excel Bar Chart? Here’s How It Works

Yes—Excel for Microsoft 365 on Windows can add a trendline to a supported 2-D bar chart. Select the chart, then choose Chart Design > Add Chart Element > Trendline > Linear; if you want another model, open More Trendline Options. A trendline on a bar chart is most useful when the categories have a meaningful order, such as months or steps in a process.

What a trendline shows on a bar chart

A trendline is a fitted line that summarizes the direction of a data series. It can make an overall upward, downward, or relatively steady pattern easier to see than by comparing each bar individually. Excel fits the line to the series values; it does not change the underlying cells or turn the bars into a different type of data.

There is an important distinction between the chart and the analysis: a standard bar chart displays categories, while a trendline uses their positions in the series as the progression across the chart. For example, if the categories are January, February, and March in that order, a trendline can summarize how the values change through the months. If the categories are unrelated products sorted alphabetically, a line through their values may look mathematical without showing a meaningful time or numeric trend.

On a horizontal bar chart, categories run down the vertical axis and values extend along the horizontal axis. The trendline overlays the selected series, but it should not be mistaken for another bar or a separate measured observation. Give it a clear legend or label when readers might confuse it with the data.

How to add a trendline in Excel for Microsoft 365

Arrange the worksheet with category labels in one column and the values for a series in an adjacent column. Keep the rows in the order that matters to your analysis.
Click the bar chart. If the workbook has multiple series, click one of the bars in the series you want to analyze so Excel selects that series, not just the chart area.
On the ribbon, select Chart Design > Add Chart Element > Trendline, then choose Linear or another listed type. Excel adds the line to the selected series.
For additional settings, choose Chart Design > Add Chart Element > Trendline > More Trendline Options. The Format Trendline pane lets you select a model and, where available, set options such as a forecast or display of the equation.
To change the line’s appearance, select the trendline and use the formatting controls in the Format Trendline pane. Use a line color and weight that remain distinct from the bars and gridlines.

You can also right-click a data series and choose Add Trendline. If that option is not shown, check that you selected an individual series and that the chart type supports trendlines. To remove one, select the trendline and press Delete, or use the Trendline menu to select None if that option appears.

Choose a trendline type that fits the data

For many simple bar-chart comparisons, a linear trendline is the clearest starting point. Other options can describe different patterns, but selecting a more complicated curve just because it follows the bars closely can make the chart harder to interpret.

Linear: A straight line that summarizes a steady increase or decrease. It is often a sensible first choice for values measured over ordered periods.
Moving average: Smooths short-term variation by averaging a chosen number of neighboring observations. It can help with noisy time-series data, but it does not show the same kind of fitted equation as a linear model. The period determines how much smoothing occurs.
Polynomial: A curved model that can represent changes in direction. The order controls the curve’s complexity; higher orders can follow individual ups and downs and may suggest a pattern that will not continue.
Exponential: A curved model for certain patterns of proportional growth or decline. It is not appropriate for data containing zero or negative values.
Logarithmic and power: These describe particular curved relationships and have data restrictions. They are generally easier to justify when the subject matter or a deliberate analysis supports that shape, rather than as a way to make a chart look smoother.

A moving average is useful when the question is whether a noisy sequence has a broader direction. A linear line is better when you want a simple summary of the overall increase or decrease. For any model, inspect the values and the chart rather than treating the selected type as proof that the relationship is real.

Make sure the category order means something

Consider monthly support requests of 42, 48, 45, 57, and 63 from January through May. A bar chart with the months in calendar order gives a trendline a reasonable sequence to summarize: the overall direction is upward, although the monthly values do not rise at every step. If the same values are attached to five product names, a trendline is not automatically meaningful. Excel uses the sequence of plotted categories, not the semantic meaning of the names.

Sort categories carefully before interpreting a line. Alphabetical sorting, ranking by value, and chronological ordering answer different questions. Sorting values from largest to smallest may be excellent for comparing products, but it changes the order that the fitted line summarizes. If the goal is to show change over time, use a date order and make sure each period is represented consistently.

When dates or numeric x-values must be treated as actual distances—for example, measurements at 1, 2, 10, and 50—the category spacing of a bar chart can mislead. A category chart treats the labels as successive positions; it does not space them according to the numeric gaps. Use an XY (scatter) chart when you need the trendline fitted against a genuine numeric horizontal axis.

When a trendline is unavailable or misleading

Excel supports trendlines on standard 2-D bar charts, but not every chart configuration allows one. Stacked and 3-D chart types are common reasons the trendline command is unavailable. If the option is disabled, first confirm that you selected a data series, then check the chart type. A standard, unstacked 2-D bar chart is a practical alternative when it suits the data.

Other issues are about interpretation rather than the menu:

Unordered categories: A trendline across unrelated labels can imply a progression that does not exist. Use it only if the order has a defensible meaning.
Too few observations: A line fitted to only a handful of points may give a strong visual impression without much evidence. Show the actual values and avoid presenting the line as a reliable forecast.
Overlapping marks: A trendline may be difficult to distinguish when it crosses wide bars or other series. Try a less cluttered chart, clearer styling, or a separate chart for the trend.
Wrong series selected: Excel adds a line to the selected data series. If it appears to describe the wrong values, remove it and select the intended series before adding it again.

Displaying the equation or R-squared value can add context, but neither proves that the model is appropriate. R-squared describes how closely a fitted model accounts for variation in the plotted data under that model; it does not show that the relationship is causal or that it will persist. On a category-based bar chart, also remember that the category positions underpin the fit.

Would another chart type communicate the trend better?

Bar charts excel at comparing amounts across categories. They are a natural choice for comparing sales by region or counts by department, especially when the categories do not represent a continuous sequence. A trendline is an optional summary, not a substitute for choosing a chart that fits the question.

For data tracked over time, a line chart is often easier to read because connected points make the sequence explicit. For paired numerical measurements, an XY scatter chart is usually more suitable: it positions points according to their actual x-values and can show a fitted trendline against those values. A bar chart remains useful when the main task is to compare the categories and the ordered pattern is secondary.

For example, to compare monthly revenue across several departments, grouped bars help readers compare departments month by month, while a line chart may better emphasize change through the year. To examine how advertising spend relates to revenue, a scatter chart is more appropriate because both variables are numeric. The chart type should follow the question, not merely the availability of a Trendline button.

Frequently Asked Questions

Can you put a trendline on a bar chart in Excel?
Yes. Excel can add a trendline to a supported, standard 2-D bar chart. Select the data series and use Chart Design > Add Chart Element > Trendline. Stacked or 3-D chart types may not support the feature.

Why is Add Trendline greyed out?
Excel may not have an individual data series selected, or the chart may use a type that does not support trendlines, such as a stacked or 3-D chart. Select a series and, if needed, change the chart to a supported 2-D type.

Can I add a trendline to a stacked bar chart?
Excel does not support trendlines on stacked chart types. Use a standard unstacked 2-D bar chart if a trendline is important, or use a line chart or scatter chart when that better represents the data.

Is a trendline on a bar chart a forecast?
Not by itself. It summarizes a fitted pattern in the plotted data. Some trendline options include forecasting settings, but extending a line beyond observed values is an extrapolation, not a guarantee of future results. Use caution, especially with few observations or changing conditions.

Should I use a trendline or a line chart for monthly data?
Use a line chart when the main point is how values change over time. Add a trendline when you also want a simplified summary of the overall direction. A bar chart can still work for monthly comparisons, but keep the months in chronological order and make the line’s role clear.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.