Excel Chart Horizontal Line: Add a Constant or Target

To add a horizontal target or constant line to an Excel chart, add a new data series whose value repeats across the chart’s categories, then change that series to a line. In Excel for Microsoft 365 on Windows, use Chart Design > Select Data > Add to include the series, followed by Chart Design > Change Chart Type > Combo to display it as a line when the chart’s main data uses columns.

This approach keeps the line tied to the chart’s data, so it can move when the target or underlying values change. A drawn shape is quicker for a visual annotation, but it does not represent a data value and may not stay aligned as the chart changes.

What a horizontal line in an Excel chart can mean

The phrase can refer to several different things. A reader might mean a constant reference line, such as a monthly sales target; a gridline that helps compare values; the chart’s horizontal axis; or a trendline. These are not interchangeable. A target line represents a chosen value, while gridlines are chart guides and a trendline is calculated from the plotted data.

For example, if a chart shows actual monthly sales and the target is $10,000, a reference line at 10,000 makes it easy to see which months reached the goal. If you instead want horizontal guides at regular intervals, add or format the chart’s gridlines. If you want to show a fitted pattern in a data series, consider a trendline—but it will not automatically equal a fixed target.

For most target or threshold uses, a separate data series is the clearest and most reliable method. The line then has a defined value at each category, can be formatted independently, and can be included in the chart legend.

Prepare the data for a constant line

A category chart needs one target value for each category. Imagine a worksheet with months in A2:A7 and actual sales in B2:B7. Put the target, 10000, in D1, and use a Target heading in C1. With the months in A2:A7, actual sales in B2:B7, and target in D1, enter =$D$1 in C2 and fill it down through C7. Each target cell will show 10000. The dollar signs keep the reference fixed when the formula is copied.

Your table will then have three columns: Month, Actual Sales, and Target. Select the table, including the headings, and insert a chart using Insert > Insert Column or Bar Chart. The target may initially appear as another set of columns. That is expected: Excel has plotted both value series using the same chart type, and you can change the target series next.

If you already have a chart, you do not need to rebuild it. Add the target series to the existing chart and set its chart type to Line. For a chart with categories, the target series should have the same number of values as the category labels. A missing or extra value can cause the line to stop early or make the chart categories appear out of sync.

Add a horizontal line to an existing chart

Enter the target values in a worksheet range, one value for each category in the chart. They can be repeated constants or references to a single target cell.
Select the chart. Choose Chart Design > Select Data. In the Select Data Source dialog, choose Add.
In Edit Series, select the target’s heading cell for Series name and the target values for Series values. Do not include the heading in the values range.
Choose OK to return to the chart. If the target appears as columns, choose Chart Design > Change Chart Type, then select Combo.
In the Combo chart settings, set the main data series to its existing type and set the target series to Line. Leave the target on the primary axis unless it has a specific reason to use a different scale. Choose OK.

The Combo option is useful when the main data is a column chart, because it allows different series in one chart to use different chart types. If the chart is already a line chart, adding the target series as another line may be enough; check its type in Change Chart Type if Excel does not display it as expected. The equivalent chart-design options are available in current Excel for Mac, although ribbon arrangement and dialog appearance can vary. In Excel for the web, chart editing options can differ; if a needed combo setting is unavailable, open the workbook in the desktop app.

Worked example: a sales target

Suppose actual monthly sales are 8,500, 10,600, 9,700, 12,200, 10,000, and 11,300, while the target is 10,000 each month. In a column chart, the repeated target series becomes a straight line at 10,000 after you change it to a line. January and March fall below the line, while February, April, May, and June meet or exceed it. The example makes the comparison visible without adding labels to every column.

To make the line more readable, select it and use the formatting controls on the Format tab or the Format Data Series pane. A contrasting solid color and a width greater than the default can help it stand apart from the columns. You can remove markers if Excel displays them: markers are useful when each category’s target value needs emphasis, but they can make a constant line look cluttered.

Use a descriptive series name such as Target or Minimum acceptable value. That name can appear in the chart legend and helps readers understand what the line means. If the chart already has a long legend, a direct label near the line’s end may be clearer, but avoid placing text over data that readers need to inspect.

Format the line and choose its scale

A reference line only communicates accurately if it uses the right axis. In a typical chart with one value scale, keep the target on the primary axis. If the target series is accidentally assigned to a secondary axis, Excel can use a different scale for it. A line that looks level may then sit at the wrong visual height relative to the columns, even though the worksheet values are correct.

Check the vertical axis labels and the target’s plotted position after changing chart types. If you deliberately use a secondary axis—for example, to combine sales with a percentage—make sure the target line belongs to the scale it is meant to describe. A target of 10,000 dollars does not belong on a percentage scale. When the chart has two vertical axes, readers should be able to tell clearly which scale applies to each series.

Formatting should support interpretation rather than imply extra meaning. A dashed line can distinguish a threshold from actual measurements; a red line may suggest a warning, so use that color only if it fits the chart’s message. Do not rely on color alone: a clear legend name or a label helps readers who cannot distinguish the colors.

Line charts, scatter charts, and other methods

For a standard line or column chart with text categories such as months, repeat the target value for every category. Excel treats the categories as positions along the horizontal axis, so the identical values connect into a horizontal series. This method also works when category labels are dates, provided the chart’s plotted categories and target values correspond.

An XY scatter chart works differently: its horizontal axis is numeric, and each point needs an x-value and a y-value. For a straight horizontal reference line across a scatter plot, add a series with two x-values at the left and right limits of the plot and the same y-value for both points. Set that series to a scatter type with straight lines and no markers. Two endpoints are sufficient for a straight line; choose x-values that cover the range you want the reference to span.

A shape is an alternative when the line is purely decorative or when you need a quick annotation. Select the chart before choosing Insert > Shapes and a line shape, then draw across the plot area. It is not linked to a numeric value, may not track changes in the axis range, and can become misaligned if the chart is resized or its scale changes. Use a data series when accuracy and future updates matter.

Gridlines are better when the purpose is to help readers estimate many values, not highlight one threshold. Select the chart and use Chart Design > Add Chart Element > Gridlines to choose a gridline option. Gridlines follow the axis scale; they do not create a custom target at an arbitrary value unless that value coincides with a gridline.

Common problems and how to fix them

The target appears as columns. The target series has the same chart type as the actual values. Change just the target series to Line using the Combo chart settings.
The line does not span the full chart. Check that the target range contains one value for every category and that the series uses the correct category labels. For an existing chart, review the ranges in Select Data.
The line is in the wrong place. Confirm that the target value is on the intended vertical axis and that the axis scale includes it. A secondary axis or an unexpected minimum and maximum can change its apparent position.
The line is invisible. It may be behind another series, use a similar color, or have a very thin stroke. Choose a contrasting line color and increase its width. Also check whether the target values are blank or outside the visible axis bounds.
The chart changes when you add data. Check whether the chart’s source range includes the new rows. If the chart uses an Excel table, adding rows within that table generally allows the chart to include the new records; still verify the plotted ranges if the target series does not extend.

A useful diagnostic is to click the line and inspect the selected series in the worksheet. If the wrong cells are highlighted, correct the series values rather than trying to repair the visual position with manual drawing. This keeps the chart’s appearance connected to the underlying numbers.

Frequently Asked Questions

How do I add a goal line to an Excel column chart? Add a worksheet series with the goal repeated for each category, include it in the chart, then use Chart Design > Change Chart Type > Combo to set that series to Line. Keep it on the appropriate value axis.

Can I add a horizontal line without changing my source data? You can add a shape with Insert > Shapes > Line, but it is not tied to a value and may move out of place when the chart changes. For a data-driven reference line, add a helper series in the worksheet; it can use formulas that refer to a target cell.

Why is my target line sloped instead of horizontal? The values in the target series may not be identical, or the series may be matched to the wrong categories. Check the plotted cells and confirm that the target value repeats across the full set of categories.

Can I add a horizontal line to an Excel scatter plot? Yes. Add a scatter series with two points: one at the left end and one at the right end of the desired x-range, with the same y-value for both. Use straight lines and remove the markers if you want a clean reference line.

Is a horizontal gridline the same as a target line? No. Gridlines are visual guides placed according to the axis scale. A target line is a plotted series at a chosen value, so it can mark a threshold that does not match one of the chart’s gridlines.

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.