How to Add Horizontal Line in Excel Bar Graph

Adding a simple horizontal line to an Excel bar graph can instantly transform it from a basic data visual into a powerful reporting tool. This single line can represent a target, an average, a benchmark, or a crucial threshold, giving your data the context it needs to tell a complete story. This guide will walk you through the cleanest and most effective methods to add that goal line, complete with step-by-step instructions.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Add a Horizontal Line to a Bar Graph?

A bar graph is great for comparing values across different categories, like sales per month or website traffic by source. But the numbers exist in a vacuum. By adding a horizontal line, you immediately answer critical business questions:

• Visualizing Targets: See which months exceeded the sales goal and which ones fell short.
• Showing Averages: Instantly spot which product categories are performing above or below the company-wide average.
• Highlighting Benchmarks: Track your performance against an industry standard or a key performance indicator (KPI).
• Defining Thresholds: Show a budget limit, a passing score, or a critical performance level that shouldn’t be crossed.

In short, a horizontal line turns your chart from a "what" display into a "so what" analysis. You're not just showing numbers, you're showing performance relative to what matters.

Method 1: The 'Combo Chart' Method (Best for Dynamic Reports)

This is the most reliable and flexible way to add a goal line to your Excel chart. It ties the line directly to your data, meaning if your target changes, your chart updates automatically. It’s the professional standard for building recurring reports and dashboards.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 1: Set Up Your Data with a Helper Column

First, you need to prepare your data. Alongside the data for your bars, create a new column for your horizontal line. The key is that the value in this new column will be the same for every row.

Let's say you have monthly sales figures and your sales goal is $150,000. Your table would look like this:

This "Sales Goal" column tells Excel where to plot the horizontal line for each corresponding category (month).

Pro Tip: Keep Your Target Dynamic

Instead of typing "$150,000" into every cell, put your target in a single cell elsewhere on the sheet (e.g., cell E2). Then, in your "Sales Goal" column, use a formula that references that cell with an absolute reference, like =$E$2. Now, if you need to change your sales target, you only have to update it in one place, and your entire chart will adjust automatically.

Step 2: Create a Combo Chart

Now that your data is ready, creating the chart is surprisingly easy with Excel’s Combo Chart feature.

1. Select your entire data set, including the headers and your new helper column.
2. Go to the Insert tab on the Ribbon.
3. In the Charts section, click on Recommended Charts.
4. A dialog box will appear. Click on the All Charts tab at the top.
5. From the list on the left, select Combo at the very bottom.

Excel will now show you a preview of your chart. It will automatically assign a chart type to each data series. By default, it usually gets it right:

• Your Sales series should have a Chart Type of Clustered Column.
• Your Sales Goal series should have a Chart Type of Line.

If Excel chose a different type, simply use the dropdown menus next to each series name to select the correct chart types. Once it looks correct, click OK.

And just like that, you have a beautiful bar graph with a clear horizontal goal line running through it.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 3: Format Your Horizontal Line for Clarity

The default line might not be visually arresting. Let's make it look more like a target line and less like another data series.

1. Click on the horizontal line in your chart to select it.
2. Right-click on the line and choose Format Data Series. A formatting pane will appear on the right side of your screen.
3. In the formatting pane, click on the paint bucket icon labeled Fill & Line.
4. Customize the line:
5. Remove the markers:

Finally, your chart should have a clear, easy-to-read goal line that provides excellent context for your sales data.

Method 2: Using 'Draw Shape' (The Quick and Static Approach)

Sometimes you don't need a dynamic, data-driven report. You just need a quick visual for a one-off presentation or email. In these cases, you can simply draw a line directly onto your chart.

Warning: Remember that this line is a static drawing. It is not connected to your data in any way. If your data changes, or if the chart axes rescale, you will have to manually readjust the line.

Step 1: Create Your Base Bar Graph

First, create your bar chart just as you normally would, using only your primary data (e.g., your "Month" and "Sales" columns).

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 2: Draw a Horizontal Line

1. Select your completed chart.
2. Go to the Insert tab on the Excel Ribbon.
3. Click on Shapes and choose the simple line shape.
4. Your cursor will change to a cross-hair. To draw a perfectly straight line, hold down the Shift key while you click and drag your line across the chart's plot area.
5. Position the line to match the desired value on the Y-axis.

Step 3: Format and Label Your Line

With the drawn line selected, a new Shape Format tab will appear on the Ribbon.

• Use the Shape Outline tools to change the line's color, weight (thickness), and dash style.
• Since this line is not connected to a legend, it's a good idea to add a label. Go to Insert > Text Box, draw a small text box next to your line, and type "Sales Target" or the specific value.

While this method is extremely fast, it's best reserved for static visuals where the data is final.

Final Thoughts

Adding a horizontal line to an Excel graph helps turn your raw data into a narrative about meeting goals, hitting averages, and staying on budget. The Combo Chart method is the professional's choice for creating robust, dynamic reports, while drawing a line is a quick fix for one-time needs. Either way, you're now equipped to add a layer of powerful context to your data visuals.

We built Graphed because we believe getting actionable insights like this shouldn't feel like an Excel puzzle. When we were running marketing and sales teams, we spent hours creating these kinds of combo charts just to answer basic questions. With Graphed, we've automated the entire process. You can connect your live data sources and then simply ask in plain English: "Show me my sales per month this year with a target line at $150,000," and Graphed builds the real-time, interactive dashboard for you in seconds.