How to Add Baseline in Excel Graph

Adding a target line to an Excel graph instantly gives your data context, showing at a glance how performance stacks up against a goal. Whether you're tracking sales against a quota, website traffic against a target, or project spending against a budget, this simple visual makes your charts far more insightful. This tutorial will walk you through a few easy methods to add a fixed or dynamic baseline to any Excel chart.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Bother Adding a Baseline?

A chart without a baseline shows you trends, but it doesn't tell a complete story. Is that upward trend in sales actually good, or are you still way below your goal? Did that dip in website traffic drop below your minimum acceptable threshold? A baseline, also known as a target line or reference line, answers these questions immediately.

Here are a few common scenarios where a baseline is invaluable:

• Sales Performance: Visualizing monthly revenue against a quarterly sales quota.
• KPI Tracking: Measuring metrics like customer response time against a service-level agreement (SLA) target.
• Budget Management: Plotting actual expenses against a budgeted limit to catch overspending early.
• Quality Control: Showing product defect rates against an acceptable tolerance level.

In short, adding a reference line turns a simple data visualization into a powerful performance management tool.

Method 1: The Easiest Way - Add Another Data Series

The most straightforward method to add a baseline is by creating a new data series in your table that contains the target value. It’s quick, easy, and works perfectly for fixed targets.

Step 1: Set Up Your Data

First, make sure your data is organized in a simple table. For this example, we’ll use a dataset of monthly sales. You’ll want one column for your labels (e.g., months) and another for your values (e.g., sales revenue).

Now, add a third column for your baseline. Let’s call it "Sales Target." If your target is $65,000 for every month, simply fill this column with that value for each row corresponding to a month.

Your data should look like this:

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Create a Combo Chart

With your data prepared, you're ready to create the chart.

1. Highlight all your data, including the new "Sales Target" column and the headers.
2. Go to the Insert tab on the ribbon.
3. In the Charts section, click on Recommended Charts. Excel often suggests a “Clustered Column - Line” combo chart, which is exactly what we want.
4. If it's not suggested, click the "All Charts" tab at the top of the window, select Combo from the left-hand menu.

In the Combo chart options, you’ll see your two data series ("Sales Revenue" and "Sales Target"). Set the chart type for "Sales Revenue" to Clustered Column and the chart type for "Sales Target" to Line. Click OK.

Excel will instantly generate a chart where the monthly sales are shown as vertical bars, and your $65,000 target is a straight horizontal line running through them. It’s immediately clear which months beat the target and which ones fell short.

Step 3: Format Your Baseline for Clarity

Your chart is functional, but you can make the baseline clearer. The default blue and orange might not distinguish a target from actual data well enough.

1. Right-click directly on the target line in your chart.
2. From the context menu, select Format Data Series...
3. A pane will open on the right. Click the Paint Can icon (Fill & Line).
4. Under the "Line" options, you can change the color (a subtle gray or black works well), increase the width to make it more prominent, and change the Dash type to a dashed or dotted line. This visually tells your audience that this line represents a goal, not an actual data point.

You can also click on the legend at the bottom and delete the "Sales Target" entry if the chart is self-explanatory, which cleans up the final look.

Method 2: Create a Dynamic Baseline that's Easy to Update

The first method is great for fixed targets, but what if your goal changes? Or what if you want to build a mini-dashboard where you can quickly change the baseline and see its impact? You can make your baseline dynamic by linking it to a single cell.

Step 1: Set Up a Target Cell

Start with the same data table as before. Instead of typing the target value into an entire column, find an empty cell outside your main data table. Let’s say cell E2.

In this cell, type your target value (e.g., 65000). You can even label the cell next to it (e.g., in D2) as "Enter Target:" so it's clear what the cell is for.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Link Your Target Column to the Target Cell

Now, go back to your "Sales Target" column. In the first cell (in our example, next to January's sales), don't type the number. Instead, type a formula that references your target cell: =$E$2.

The dollar signs ($) are important! They make the cell reference "absolute," which means if you drag the formula down, it will always point to cell E2 instead of trying to move down to E3, E4, etc. Press Enter, then click the small square in the bottom-right corner of the cell and drag it down to fill the rest of the column.

Now, your entire "Sales Target" column is powered by the value in cell E2.

Step 3: Create and Format the Chart

Follow the exact same steps from Method 1 to create and format your combo chart. The process is identical. The magic happens after the chart is made.

Now, if you want to see what performance would look like against a higher target of, say, $70,000, you don't need to retype a whole column. Just go to cell E2, change the value to 70000, and press Enter. The baseline on your chart will instantly and automatically jump to the new position. This transforms a static report into an interactive analysis tool.

Method 3: The Advanced Scatter Plot for Ultimate Control

Sometimes you need to add a baseline that isn't tied to your primary data categories, or maybe you want to add a vertical line. For these scenarios, the XY Scatter plot method offers maximum flexibility, though it requires a slightly more complex approach.

Let's say you want to add a horizontal line at $60,000 but only for the first six months (Jan to Jun) to show a mid-year goal change.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Define the X and Y Coordinates for Your Line

An XY Scatter plot draws a line between coordinates. To draw a horizontal line, you need a start point and an end point. The Y-coordinate (the vertical position) will be the same for both, and the X-coordinate will define the start and end.

In some empty cells, create two data points to define your line:

Here, we are telling Excel: start the line at X-position 1 (January) and Y-position $60,000, and end it at X-position 6 (June) and Y-position $60,000.

Step 2: Add the Scatter Series to Your Existing Chart

1. Start by creating your main chart (e.g., a column chart of your monthly sales) just like before, but without any target column in your source data.
2. Right-click on the chart and choose Select Data...
3. In the "Legend Entries (Series)" box on the left, click the Add button.
4. The "Edit Series" window will pop up. For the Series X values, select your X-Axis cells (the ones containing 1 and 6).
5. For the Series Y values, select your Y-Axis cells (the ones containing $60,000).
6. Click OK twice to close the windows. You'll see two odd-looking dots appear on your chart. Don't worry, that's what we want.

Step 3: Change the Chart Type to a Scatter with Straight Line

1. Right-click on one of the new data dots in your chart and select Change Series Chart Type...
2. In the dialog box, you'll see your two series listed. Find the new series you just added.
3. Change its chart type to XY (Scatter), specifically the subtype called Scatter with Straight Lines.
4. Excel will probably create a secondary axis for this new series. Uncheck the "Secondary Axis" box for the scatter series to keep things on the same scale.
5. Click OK.

Just like that, you'll have a perfectly positioned horizontal line that spans exactly from January to June. You can now format this line (make it dashed, change the color) just as we did in the first method.

Final Thoughts

Adding a baseline is a small step that dramatically improves the narrative power of your Excel charts. Whether you use the simple data series method for a quick visualization, the dynamic cell-linked method for interactive analysis, or the scatter plot for precise control, you can present data that clearly shows performance against key targets, making your reports more effective and your insights sharper.

While mastering these functions in Excel is a valuable skill, it's often just one part of the wider chore of manual reporting. Creating these charts week after week often starts with the tedious process of downloading CSVs from platforms like Google Analytics, Facebook Ads, or Shopify and stitching all the data together. This is where we built Graphed to simplify the entire reporting workflow. We connect directly to your marketing and sales platforms, so you can stop wrestling with spreadsheets and start asking for the dashboards you need in plain English - complete with targets and comparisons built right in.