How to Add Horizontal Line to Excel Chart in 3 Easy Steps

Adding a horizontal line to an Excel chart helps identify key values such as averages, targets, or thresholds. When tracking sales or analyzing trends, a reference line makes patterns easier to interpret. Excel does not offer a direct one-click option for this feature, but built-in tools allow you to add the line effectively. The most reliable method is to include a secondary data series. Alternative options include error bars and trendlines, though each has drawbacks.

Use a Secondary Data Series

The best way to insert a horizontal line is by adding a new data series with a fixed value. This approach works with column, line, and scatter charts and gives full control over placement and appearance.

Assume monthly sales data is in column B (B2:B13) and the target is $50,000. In column C, label cell C1 as “Target” and enter 50000 in cells C2 through C13. Select the chart, go to the Chart Design tab, and click Select Data. Click Add under Legend Entries, name the series “Target,” and set the Y-values to C2:C13.

Excel will display the new series on the chart. If the chart is a column type, the target values appear as extra columns. To correct this, right-click the new series, choose Change Series Chart Type, and select a line chart type. This overlays a straight horizontal line at $50,000.

To adjust the line’s appearance, right-click it and select Format Data Series. Change the color, thickness, and line style—dashed or dotted lines are often suitable for reference markers. Effects like shadows can be added if needed.

To include a label, click the chart and use the Chart Elements button (the plus sign). Enable Data Labels, then choose the option that displays values. Edit one label to show “Target: $50K” if preferred. Avoid labeling every point to keep the chart clean.

This method works well in dashboards. If the target changes, update the values in column C and the line updates automatically. Multiple reference lines, such as upper and lower limits, can be added by repeating the process with additional columns Microsoft Excel.

Apply Error Bars as Reference Lines

Error bars usually show data variability, but they can be adapted to display a horizontal reference line, such as an average.

First, calculate the average of the data. If sales figures are in B2:B13, enter =AVERAGE(B2:B13) in cell D2. Create the chart using the original data. With the chart selected, go to Chart Design > Add Chart Element > Error Bars > More Error Bars Options.

In the format pane, select the data series and set the error bar direction to Plus or Both. Under Error Amount, choose Fixed value and enter 0. Then set Cap to No Cap. This removes vertical bars.

Error bars are vertical by default. To create a horizontal effect in a column chart, combine them with a scatter plot or use a secondary axis. This requires additional steps and may not produce a clean, full-width line.

Due to these issues, this method is less reliable for general use. It may be useful in statistical reports where error bars are already part of the analysis, but for most users, it is not ideal.

Insert a Trendline for Linear Patterns

Trendlines indicate data direction, such as growth or decline. While not intended for flat reference lines, they can be used to create a horizontal line by setting the slope to zero.

Start with a scatter or line chart. Click on the data series, go to Chart Design > Add Chart Element > Trendline > More Trendline Options. Choose Linear. By default, Excel fits the line to the data’s trend.

To create a horizontal line, override the slope. Excel does not allow direct slope input in standard charts. A workaround is to create a helper column where each value equals the desired level—such as 50000—plot it as a separate series, and apply a linear trendline. Since all values are identical, the trendline will be flat.

Another option is to use Moving Average under Trendline. Set the period to match the full data range. This smooths the line into a single level, approximating a flat reference. However, the result is not exact and depends on data distribution.

This method works best when trendlines are already used for forecasting. In financial reports, pairing a revenue forecast with a horizontal break-even line can help evaluate performance. However, labeling and formatting the line independently is difficult.

Trendlines update automatically when data changes unless fixed. This can be helpful in dynamic models but problematic if a static reference is needed.

For most cases, the secondary data series method is more accurate and easier to manage.

Key Takeaways

• The most effective way to add a horizontal line to an Excel chart is by adding a new data series filled with a constant value, such as a target or average.
• Format the new series as a line and adjust its style, color, and labels to improve clarity without distracting from the main data.
• Error bars and trendlines can simulate horizontal lines but have limitations in formatting and positioning, making them less ideal for general use.
• Always test your chart after updating data to ensure reference lines adjust correctly, especially in live dashboards Microsoft Excel.