Adding a horizontal line to show a target or average

A horizontal line in an Excel chart marks a specific value — a sales target, an average, a budget limit, or a threshold you want to compare your data against. Excel calls this a reference line, and you add it by inserting what's called an axis line or by adding a new data series that sits flat across your chart.

The simplest method is to add a second data series to your existing chart. This series contains the same value repeated for every data point, which creates a perfectly horizontal line. The alternative — using axis lines — works only in certain chart types and gives you less control over where the line appears.

Key Takeaways

  • The most reliable way to add a horizontal line is to create a second data series with a constant value repeated for each point on your chart.
  • You can use the "Add Chart Element" menu to insert axis lines, but this works only in column, bar, and scatter charts, not in line charts.
  • Format your reference line separately from your main data by changing its color, thickness, and style to make it stand out.
  • If you need the line to appear behind your data instead of in front, right-click the line series and choose "Format Data Series," then set the overlap to 100%.

Adding a horizontal line using a second data series

Start with your chart already created in Excel. Right-click on the chart and select "Select Data" to open the data range dialog. Click "Add" to insert a new data series. In the dialog box, give your series a name (like "Target" or "Average") and set the values to the number you want the line to represent — for example, if your target is 50,000, type 50000 for every row.

Once you add the series, Excel plots it as points on your chart. Right-click the new series and choose "Change Series Chart Type." Select "Line" from the list, then click "OK." Your horizontal line now appears across the chart. If the line shows as a series of points instead of a continuous line, you may need to adjust the chart type settings — go back to "Change Series Chart Type" and make sure "Line" is selected with points connected.

This method works in almost every chart type and gives you complete control. You can move the line up or down by editing the data series values, and you can format it independently from your main data.

Using axis lines for column and bar charts

If you have a column or bar chart, you can add a horizontal line directly without creating a second data series. Click on your chart to select it, then go to the "Chart Design" tab at the top. Click "Add Chart Element," then hover over "Lines" and select "High-Low Lines" or "Series Lines" depending on your chart type.

This approach is faster than adding a data series, but it has limits. High-Low Lines work only if your data already has high and low values — they connect the highest and lowest points in each category. Series Lines connect points within a series and do not create a true reference line at a specific value. For most situations where you want a target or average line, the data series method is more flexible.

Formatting your reference line to stand out

Once your horizontal line is in place, format it so readers notice it when ready. Right-click the line series and select "Format Data Series." In the panel that opens, click the "Line" icon and choose a color that contrasts with your main data — red for a target, gray for an average, or blue for a threshold.

Increase the line width to make it more visible. Under "Line Style," you can also change the line to dashed or dotted if you want to distinguish it from your actual data. A dashed line often signals a goal or projection, while a solid line suggests a measured value like an average.

If your reference line appears in front of your data and blocks the view, right-click the line series again, select "Format Data Series," and look for the "Series Overlap" setting. Set it to 100% to move the line behind your data points.

Adding a label to explain what the line represents

A horizontal line without a label can confuse readers. Right-click your reference line and select "Add Data Labels." In the dialog, choose "Value" to show the number the line represents. Position the label at the end of the line so it does not overlap your main data.

Alternatively, add a text box to your chart. Click "Insert" at the top, select "Text Box," and draw a small box near your line. Type a label like "2024 Target" or "Monthly Average." This approach gives you more control over placement and wording than automatic data labels.

Troubleshooting a horizontal line that does not appear straight

If your line angles or slopes instead of staying horizontal, check your data series values. Open "Select Data" again and verify that every cell in your reference line series contains the exact same number. Even a single different value will cause the line to slope toward it.

If the line appears but is barely visible, it may be hidden behind your main data or formatted in a color too similar to your background. Right-click the line, select "Format Data Series," and change the color to something bright and distinct. Increase the line width to at least 2 or 3 points.

If you added the line using "High-Low Lines" and it is not showing at all, your chart type may not support it. Switch to the data series method instead — it works reliably across all chart types.

When to use a reference line instead of other methods

A horizontal reference line works best when you want to compare actual results against a single target or benchmark. If you need multiple lines at different values, add multiple data series using the same method. If you need to show ranges — like a minimum and maximum acceptable value — add two reference lines, one at each boundary.

For charts where the horizontal line is the main focus and your data is secondary, consider flipping your approach: make the reference line your primary data series and format it prominently, then add your actual data as a secondary series in a lighter color.

Frequently Asked Questions

Can I add a horizontal line to a pie chart?

No. Pie charts do not use axes or data series in the same way as column, bar, line, or scatter charts. If you need to show a target or average alongside categorical data, use a column or bar chart instead, which allows you to add a reference line.

How do I make the horizontal line appear behind my data instead of in front?

Right-click the reference line series, select "Format Data Series," and find the "Series Overlap" or "Overlap" setting. Set it to 100% to move the line behind your data points. In some Excel versions, this setting appears under "Series Options."

What if I want the line to stop at a certain point instead of spanning the entire chart?

The data series method creates a line that spans the full width of your chart. If you need a line that ends partway across, use a text box or drawing shape instead. Click "Insert," select "Shapes," choose a line, and draw it manually at the length and position you want.

Can I change the horizontal line to a different color for different sections of the chart?

No. A single data series displays in one color throughout. If you need different colors in different sections, you would need to create separate charts or use a more complex workaround with multiple overlapping charts — usually not worth the effort for a straightforward reference line.

How do I remove a horizontal line I no longer need?

Right-click the line series in your chart and select "Delete." If you added it as a data series, you can also open "Select Data," click the series name, and click "Remove." The line disappears when ready.