How to Add a Target Line in Google Sheets Graph

Putting a target line on your Google Sheets graph is one of the fastest ways to tell a clear story with your data. It instantly shows whether you're hitting your goals, falling short, or cruising past your expectations. This article will guide you through the process step-by-step, covering how to add a simple, static goal as well as a dynamic benchmark like an average.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Bother with a Target Line?

A chart without context is just a collection of shapes. Imagine looking at a bar chart of monthly sales. You see that January numbers were $45,000, February at $38,000, and March at $52,000. Is that good? Bad? About average? You have no idea.

Now, add a horizontal line across the chart at the $50,000 mark. Instantly, the picture becomes clear:

• You were close to the target in January.
• You missed it in February.
• You exceeded it in March.

That single line transforms your chart from a simple data report into a powerful performance dashboard. It answers the most important question at a glance: "How are we doing compared to where we want to be?" It works for sales quotas, website traffic goals, project budgets, support ticket response times, or any other key performance indicator (KPI).

Method 1: Creating a Standard Target Line with a Fixed Goal

This is the most common use case. You have a fixed goal (e.g., a monthly sales quota, a project budget) and you want to visualize your actual performance against it. We'll use a sales report as our example.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Prepare Your Data Table

Before you create a chart, you need to structure your data correctly. The trick is to create a separate column for your target and fill in the goal for every single row of your dataset.

Let's say your monthly sales target is $15,000. Your sheet should look like this:

Column A: Month Column B: Actual Sales Column C: Sales Target

Like so:

• A1: Month | B1: Actual Sales | C1: Sales Target
• A2: January | B2: $12,500 | C2: $15,000
• A3: February | B3: $16,000 | C3: $15,000
• A4: March | B4: $14,000 | C4: $15,000
• A5: April | B5: $17,500 | C5: $15,000

Why repeat the target value? Because Google Sheets needs a data point for every point on the X-axis (your months) to draw a continuous horizontal line. If you only put $15,000 in cell C2, the line would just be a dot and disappear.

Step 2: Insert a Combo Chart

With your data set up, it's time to build the visualization. The Combo Chart is the perfect tool for this because it lets you represent different data series as different chart types - like bars for sales and a line for your target.

1. Highlight your entire data range, including the headers (from cell A1 to C5 in our example).
2. Navigate to the top menu and click Insert > Chart.
3. Google Sheets will generate a chart for you. It probably won't be the right one - it often defaults to a stacked bar chart or something similar. Don't worry, that's normal. The Chart Editor tool should appear on the right side of your screen.

If the Chart Editor disappears, just double-click on your chart to bring it back.

Step 3: Configure Your Chart and Series

Here’s where you tell Google Sheets exactly how you want the chart to look. In the Chart Editor pane:

1. Make sure you're in the Setup tab.
2. Under Chart type, scroll down until you see the Combo chart option and select it. This is the one that looks like bars and a line together.
3. Your chart should automatically update. Google Sheets is pretty smart and will often guess correctly, assigning "Actual Sales" to bars and "Sales Target" to a line. If it doesn't, you'll need to adjust it manually in the 'Customize' tab.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Style Your Target Line for Clarity

Your chart is now functionally correct, but you can make it much easier to read with a few design tweaks. In the Chart Editor, click over to the Customize tab.

1. Expand the Series dropdown. This is where you control the look of your individual data sets.
2. Select your "Sales Target" series from the dropdown list.
3. Change the Color: A neutral grey or black often works better for a target line than a loud, distracting color.
4. Adjust Line Style: To make it stand out as a benchmark, change the Line dash type to a dashed or dotted line.
5. Remove Points: The default line has circles or "points" on each data marker. For a clean target line, change the Point size to "None".
6. Adjust Thickness: A 2px or 4px Line thickness is usually perfect.

You now have a clean, easy-to-read chart that beautifully visualizes performance against a fixed goal.

Method 2: Adding a Dynamic Target Line (Like an Average)

Sometimes your "target" isn't a fixed number but a calculated benchmark, like the average performance across all data points. This is useful for identifying top performers or outliers. For example, you might want to see which blog posts are getting more-than-average traffic or which products have above-average sales.

We'll adapt our previous example to create an average sales line.

Step 1: Calculate the Average Using a Formula

Instead of manually typing a target, we'll use the AVERAGE() function. In our example table, we'll use Column D for this.

1. In cell D2, type the following formula: =AVERAGE($B$2:$B$5)
2. Press Enter. This will calculate the average of all the "Actual Sales" figures.
3. Click back on cell D2, grab the small blue square (the fill handle) in the bottom-right corner, and drag it down to the last row of your data (D5).

The $ signs in the formula are critical. They create an absolute reference. This means that when you drag the formula down, the range B2:B5 won't change. If you omitted them (=AVERAGE(B2:B5)), dragging the formula would change the range to B3:B6, B4:B7, etc., which would break your calculation. Each cell in the 'Average' column will now display the same average value, which is exactly what we need for our trendline.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Add the New 'Average' Data to Your Chart

Now that you have the new data series, you need to add it to your graph.

1. Double-click your chart to open the Chart Editor.
2. In the Setup tab, click on the data range field (it probably says A1:C5).
3. Update the range to include your new 'Average' column. In our case, change it to A1:D5.

Google Sheets will add the new data to your chart, likely as another set of bars. We will fix that next.

Step 3: Customize the New Series

Just like before, we'll format the new series to appear as a line benchmark.

1. Go to the Customize > Series section in the Chart Editor.
2. Select your new 'Average' series from the dropdown menu (it may be named after its header).
3. Change its Type to Line.
4. Follow the same styling steps from Method 1: pick a distinct color (maybe a shade of green), make it a dashed line, set the point size to none, and choose an appropriate thickness.

You can now instantly see which months performed above average and which performed below, providing another rich layer of insight to your report.

Final Thoughts

Adding a target or benchmark line is a simple technique that dramatically improves the impact of your Google Sheets charts. By turning raw numbers into a clear story of performance vs. expectation, you empower anyone looking at your report to understand the results in seconds, not minutes.

As you build more reports, you might find that constantly formatting data and tweaking charts in spreadsheets takes up valuable time. At Graphed, we created a tool to automate this entire process. Instead of setting up columns and formulas, you simply connect your data sources (like Google Analytics, Salesforce, or Shopify) and ask for the report you want in plain English. For example, "Show me a bar chart of monthly Shopify revenue for the last year and add a target line at $20,000." We instantly build a live, interactive dashboard for you, no spreadsheet wrangling required.