Add a Goal Line to an Excel Chart: Steps That Work

To add a goal line to an Excel chart, add a second data series containing the goal value for every category, then format that series as a line. For a column chart, use a combo chart so the actual values remain columns and the goal series becomes a horizontal line.

How a goal line works

An Excel chart draws each series from data in the worksheet. A goal line is usually just another series: if the target is 100, the series repeats 100 at each date, product, or other category. Excel connects those values, creating a flat line across the plot area. Because the line is connected to cells, it can update when the target or the chart’s source data changes.

For example, a monthly sales chart might show actual sales of 82, 96, 109, 91, and 117 against a monthly goal of 100. The goal series is 100 for all five months. The resulting line makes it easy to see which months are below or above the threshold without changing the actual sales values.

This is different from drawing a line shape on top of a chart. A shape is a visual annotation, not a data series: it may not move correctly if the chart is resized, and it does not reflect changes to the worksheet. Use a data series when the goal should track the chart’s categories or update with the data. A shape is suitable for a one-off illustration that will not need to respond to data changes.

Prepare the worksheet data

Put the categories, actual values, and target values in adjacent columns, with a heading for each column. For example, use this layout:

Column A: Month
Column B: Actual sales
Column C: Goal

Enter the goal beside every category. If the goal is 100 for January through May, enter 100 in each of the five goal cells. A repeated value is intentional: Excel needs one plotted value for each category to draw the line across the chart. If goals differ by month, enter each month’s own target instead; the series will then rise or fall to match those values.

Keep the goal values on the same scale and in the same units as the actual values. If sales are shown in dollars, use dollar targets; if the chart shows percentages, use percentage targets. A mismatch in units can put the series far outside the visible axis range and make it seem as if the line did not appear.

Add the goal line when creating a chart

Select the category, actual, and goal columns, including their headings.
Choose Insert and insert a chart that suits the actual values, such as a clustered column chart.
If Excel displays the goal as a column too, select the chart and choose Chart Design > Change Chart Type.
In the combo chart options, set the actual series to Clustered Column and the goal series to Line. Leave Secondary Axis unchecked when both series use the same units and scale.
Select OK, then check that the line crosses the plot area at the expected value.

The exact chart type you start with is not critical; the key step is assigning the goal series a line chart type. If all the values are already in one range, Excel may initially choose a chart that treats each column alike. Changing the goal series to a line makes its purpose clearer and keeps the actual data in its original column format.

Add a goal line to an existing chart

In Excel for Microsoft 365 on Windows, first add the goal values to the worksheet in a column aligned with the chart’s categories. Select the chart, then choose Chart Design > Select Data. In the Select Data Source dialog, choose Add. Enter or select the heading cell for Series name and the goal cells for Series values, then confirm the dialogs. The series values should contain the numbers, not the heading.

Once the series is in the chart, choose Chart Design > Change Chart Type. Select Combo, and set the new goal series to Line. Keep the actual series as its existing chart type. In the same dialog, review the Secondary Axis option before confirming. When both series represent the same measure, a shared axis is generally the clearest choice.

If the chart is a line chart already, adding a goal series may be enough: Excel will connect the new values as another line. You can still change its color, width, or markers to distinguish it. For a horizontal bar chart, a line series may not create the kind of horizontal threshold readers expect; consider switching to a column chart or using a carefully aligned shape if the chart type must remain unchanged.

Choose a chart type and axis

A column chart with a line goal is a common choice for comparing actual values across discrete categories. A line chart with a goal series works well for dates or other ordered categories. In both cases, each target value needs to correspond to the category at the same position. If the category labels and goal values have different lengths or are in a different order, the line can be misplaced or the chart can display unexpected points.

Use a secondary axis only when the goal series is genuinely measured on a different scale from the actual series, or when a deliberate chart design requires it. A secondary axis can make a series visible, but it can also create a misleading impression: the same visual height may represent different values on the two axes. If you use one, make both axes visible and label them clearly. Do not use a secondary axis as the first fix for a missing line; first check the series range, chart type, and primary-axis scale.

For a simple target such as a sales quota, a repeated value on the same axis is usually easier to interpret. For targets expressed in a different unit, such as a percentage target alongside dollar amounts, decide whether a combined chart is meaningful before adding an axis. A reader should be able to tell what the line measures and how its scale relates to the bars.

Format the line so readers can interpret it

Select the goal line and use the chart formatting controls to choose a contrasting line color and a visible width. A dashed line can distinguish the target from actual values without relying on color alone. If the chart has many categories, markers on every goal point can make the line cluttered, so a plain line may be easier to read. Keep the goal series in the legend and give it a useful name such as Monthly goal rather than Series 2.

Consider labeling only the final point when the target is constant. A label on every category can crowd the chart and repeat the same number unnecessarily. Excel’s chart data labels can be applied to a series, but the available options depend on the chart type and version. You can also explain the target in the chart title or a short note. If using a shape or text box as an annotation, make sure it does not hide data and remains understandable when the chart is printed or shared.

Axis bounds affect how prominent the line appears. If Excel automatically chooses a vertical maximum much higher than the data, the goal can look close to the bottom; if the axis is tightly cropped, small differences may look dramatic. Set bounds only when doing so preserves an honest view of the data, and keep the axis labels visible. A goal line shows a reference point, not proof that performance is good or bad by itself.

Keep the goal line current

A goal series linked to worksheet cells updates when those cells change. To make future additions easier to manage, consider converting the source range to an Excel table: select the range and choose Insert > Table. Tables expand when rows are added, and charts based on table data can include new rows as the table grows. Check the chart after extending the data, especially if the new categories were added outside the original source range or if the workbook uses a manually specified chart range.

If one target applies to every period, repeating the target in each row is transparent and dependable. If each row has an independently calculated or negotiated target, store those targets with the related records rather than assuming one constant. That makes it easier to audit the chart and to explain why the line changes from one category to another. Avoid entering the goal only as a manually typed chart value when the worksheet should be the source of truth.

Common problems and how to fix them

The goal appears as columns. The series has not been assigned a line type. Open Chart Design > Change Chart Type and change only the goal series to Line.
The line is missing. Check that the goal series is included in Select Data, that its values are numeric, and that the plotted category count matches the number of target values. Also check whether the vertical axis bounds include the target.
The line appears at the bottom. The target may be blank, stored as text, or on a scale far smaller than the actual values. Confirm the cell contents and units, then inspect the axis settings.
The line slopes unexpectedly. The goal values may not all be the same, or they may be paired with categories in the wrong order. Review the worksheet rows and the series range.
The chart has two confusing scales. Check whether Secondary Axis is enabled for the goal series. Use a shared axis when the measures are comparable, or label both axes clearly when separate scales are necessary.
The line disappears after editing data. The chart’s source range may not include new rows. Update it through Chart Design > Select Data, or use a table-based source and verify that the chart includes the added records.

On Excel for Mac, the chart concepts are the same, and the ribbon generally includes Chart Design and Select Data; dialog placement and some controls can differ slightly by release. Excel for the web also supports common chart editing, but some chart-formatting choices may be more limited than in the desktop app. If a combo-chart control is unavailable in the version you are using, open the workbook in desktop Excel to set the individual series types.

Frequently Asked Questions

Can I add a horizontal goal line without changing my data?
Yes, you can draw a line shape over the chart, but it is a static visual mark and may not stay aligned when values, axes, or chart size change. A goal data series is better for a chart that should update with the worksheet.

Why does my goal line show as bars?
Excel is plotting the goal as the same chart type as the actual series. Use Chart Design > Change Chart Type, choose Combo, and set the goal series to Line.

Do I need to repeat the target value for every month?
For a standard category-based chart, yes: provide one target value for each category. Repeating a constant target creates a flat line; use different values where the target changes.

Should the goal line use a secondary axis?
Usually not when actual and goal values use the same units. A secondary axis is appropriate only when the scale is different or there is a clear reason to use one; label both axes so readers are not misled.

Can a goal line update automatically when I change the target?
Yes. Link the chart series to goal cells in the worksheet. Changing those cell values updates the plotted line, provided the chart still points to the correct range.

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.