Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Add a Point on a Graph in Excel

Cody Schneider••8 min read

Adding a single, standalone point to a graph in Excel can seem tricky, but it’s a powerful way to highlight a key event, mark a target, forecast, or call attention to a specific milestone. Whether you're tracking sales figures and want to pinpoint a campaign launch or analyzing website traffic and need to mark a new feature release, this technique turns a standard chart into a more compelling story. This tutorial will walk you through several practical methods to add and format a single data point on your Excel charts.

GraphedGraphed

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.

Watch Graphed demo video

First, Set Up Your Basic Chart

Before we can add a specific point, we need a chart to work with. Let’s assume you have a simple set of data, like monthly sales, that you want to visualize.

Here’s our sample data:

Month   | Sales
--------|-------
Jan-23  | $4,500
Feb-23  | $5,200
Mar-23  | $4,800
Apr-23  | $6,100
May-23  | $5,900
Jun-23  | $7,200

To create a basic line chart:

  1. Select your entire data range (in this case, A1:B7).
  2. Go to the Insert tab on the Ribbon.
  3. In the Charts group, click on the "Insert Line or Area Chart" icon.
  4. Choose the "Line with Markers" option for good visibility.

You now have a standard line chart showing your sales trend. Now, let’s say you launched a major marketing campaign in mid-April and want to add a point to the chart to represent the exact sales result on that day, which was an anomaly worth noting.

Method 1: Add a New Data Series for a Single Point

The most straightforward method is to treat your single point as its own, new data series. This keeps it separate from your main data, making it easy to format differently and label distinctly.

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.

Step 1: Get Your Data Point Ready

Find some empty cells in your worksheet and enter the information for your new point. It's best practice to create columns for the x-axis value (Month), y-axis value (Sales), and an optional label.

For our example, let's say the campaign launch result was a big sale worth $8,000 in April. You’d need two cells: one for the X value ("Apr-23") and one for the Y value ($8,000).

Let's place this in cells D2 and E2:

  • Cell D2: Apr-23
  • Cell E2: $8,000

Step 2: Add the New Point to the Chart

Now, we'll add this single point to your existing graph.

  1. Right-click anywhere on your chart and choose Select Data… from the context menu.
  2. The "Select Data Source" dialog box will appear. Under the "Legend Entries (Series)" section on the left, click the Add button.
  3. An "Edit Series" dialog box will open. Here’s how to fill it out:
  4. Click OK on the "Edit Series" box, and then OK again on the "Select Data Source" box.

You will now see a new point on your graph, likely in a different color. It will also appear in the legend as "Campaign Launch."

Step 3: Format the Point to Make It Stand Out

Your new point shares the default formatting, so let's make it more noticeable.

  1. Click once on the new data point to select it. Be careful not to select the whole series if you have more than one point.
  2. Right-click the selected point and choose Format Data Point….
  3. The Format panel will open on the right. Click the Paint Can icon for "Fill & Line."
  4. Under the Marker section, you can change its appearance:

Method 2: Use a Combo Chart with a Scatter Plot Overlay

What if your data point doesn’t fall neatly on an existing month? For example, the marketing campaign was launched on April 15th, not at the beginning or end of the month. The first method can't handle this precise positioning. The solution is to use a "combo chart," overlaying a scatter (XY) plot point on your existing line chart.

This gives you ultimate control over the point's exact placement.

GraphedGraphed

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.

Watch Graphed demo video

Step 1: Set Up Your Point with Numerical X/Y Coordinates

Scatterplots need numerical values for both the X and Y axes. Our Y-axis (Sales) is already a number, but our X-axis (Months) is text.

For chart types like line, bar, or column using categorical labels on the x-axis, each one is internally referenced as a numeral: Jan = 1, Feb = 2, Mar = 3...

Excel handles dates as serial numbers where January 1st, 1900, is 1. If your horizontal axis uses actual dates, you just need to ensure the single event date is formatted for Excel the same way.

If our campaign peak was exactly on "Apr-23", its X coordinate would be 4. Since it occurred between April and May, we could give it an X coordinate of 4.5.

In your empty cells, set it up like this:

  • Cell D2 (X-Value): 4.5
  • Cell E2 (Y-Value): $8,000

Step 2: Add the Point and Convert Its Chart Type

The process starts similarly to Method 1, but with a crucial extra step.

  1. Right-click your chart and select Select Data….
  2. Click Add and fill in the "Edit Series" box as before, pointing to your new XY coordinates in D2 and E2. When you click OK, Excel will add the point incorrectly, likely creating a weird extra line. This is expected.
  3. Now, right-click the chart area again and select Change Chart Type….
  4. At the bottom of the dialog box, you'll see a section for each series in your chart (likely "Sales" and "Campaign Launch").
  5. Find your new point series ("Campaign Launch") and click the dropdown menu next to it. Change its chart type from "Line" to XY (Scatter).
  6. Leave the "Secondary Axis" checkbox unchecked for this example. Click OK.

Your point now appears as a free-floating dot, precisely positioned on the chart based on its numerical coordinates. You can format this point just as we did in Method 1 by changing its marker shape, size, and color to make it stand out.

Advanced Tips for Labeling and Context

Once you've added your point, how you label it makes all the difference in communicating its importance. Standard labels can be good but here's how to create more professional and impactful annotations.

Custom Data Labels

A simple number isn't always enough context for a data label. Here's how to display custom text so people immediately know the meaning behind the point that has been featured.

  1. First, add a descriptive label in a nearby cell, for instance, in F2, type: "Campaign Launch Day: $8,000!"
  2. Right-click on your specially marked data point on the chart and select Add Data Label. A number (its Y-value) will appear.
  3. Now, right-click on that new label and choose Format Data Label….
  4. In the "Label Options" section of the format pane, look for "Label Contains" and check the box for Value From Cells.
  5. A data label range selector will then appear. Select cell F2 (which contains your custom text). At the same time, uncheck the 'Y Value' and 'Show Leader Lines' options if you'd like.
  6. Your label will now display the descriptive text from cell F2, giving anyone who views them immediate context. You can move that label to different positions around the point, for example: center, left, right, above, or below it.

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.

Using Drop Lines for Emphasis

Another strong visualization tactic to pinpoint an important moment for the viewer is using a drop line that connects the marker to the horizontal axis.

  1. Select just the single, highlighted data point alone.
  2. From your Excel ribbon, navigate to Chart Design > Add Chart Element > Error Bars > More Error Bar Options for more flexible customization opportunities.
  3. Within the "Format Error Bars" side panel, for direction, select Minus. Additionally, for the ends choose 'No Cap'.
  4. Fix the level of Percentage to your desired value. If you want the line to hit the horizontal axis (which we're trying to achieve in this example), set the percentage amount to 100%.

This visual effect quickly guides the audience's eyeline and provides more precision when trying to pinpoint exactly where on the horizontal axis that single data point occurred.

Final Thoughts

Adding a single strategic point to a graph is a simple skill that dramatically boosts the narrative power of your reports in Excel. From the straightforward method of adding another data series to a highly flexible scatterplot combination, these methods let you move beyond a generic chart and spotlight the data that really counts.

Creating and manually fine-tuning these visualizations in Excel is useful, but the process can be slow and repetitive, especially when you need reports consistently. With tools like Graphed , we shift this entire workflow from manual clicking to simple conversation. You just connect your actual data sources (like Google Analytics, Shopify, QuickBooks ...) and ask in a conversational style for the insight you want. For example, 'Compare website traffic from the past 90 days, calling out the day we got our press mention,' to have the chart then get instantly made together for you, complete and always being updated with live numbers at your disposal.

Related Articles