How to Add a Point on a Graph in Google Sheets

Ever look at a line graph and wish you could just point to a specific spot and say, "This, right here, is when everything changed"? Placing a single, customized data point onto a graph in Google Sheets does exactly that, letting you visually bookmark milestones, anomalies, or important events. This article will show you the straightforward method to add and format an individual point on your Google Sheets graphs to make your data tell a clearer story.

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 Add a Single Point to a Graph?

Standard charts show trends, but they often lack context. Adding a specific point helps you layer that context directly onto the visuals, answering the "what happened here?" question before it's even asked. It’s a simple but powerful way to guide your audience's attention.

Consider a few common scenarios:

• Marketing Analytics: You could plot your website traffic over a month and add a distinct point to mark the day a major ad campaign was launched. Did traffic spike right after? The visual makes it obvious.
• Sales Reporting: On a chart showing monthly recurring revenue (MRR), you could highlight the date you launched a new pricing plan or ran a promotional flash sale.
• E-commerce Performance: When charting daily sales, you can place a "star" marker on Black Friday or the day an influencer post went live to show its direct impact on revenue.
• Project Management: A burndown chart could have a point indicating a major change in project scope or a new developer joining the team.

In all these cases, the isolated point acts as a visual signpost, transforming a simple data chart into a narrative about cause and effect.

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

Setting the Stage: Structuring Your Data

The trick to adding a single point isn't a hidden chart setting, it's about how you structure your data. The core idea is to create a separate data series in your spreadsheet that contains only the point you want to highlight.

Let's say you have a simple dataset tracking website sessions over a two-week period. Your initial data in Google Sheets probably looks something like this:

Initial Data Table

[Image: Basic table in Google Sheets with two columns: Date and Sessions.]

Now, imagine you launched a new marketing campaign on January 8th, and you want to specifically call out that day’s performance on your graph. To do this, you'll need to add a third column. Let's call it "Campaign Launch."

This new column will be almost entirely empty. It will only contain a value in the row corresponding to the point you want to plot - January 8th. The value you enter should be the same as the "Sessions" value for that day (in this case, 3,101).

Here’s how the updated table looks:

Updated Data Table with an Extra Column

[Image: Google Sheets table with a third column named 'Campaign Launch' containing a single data point value.]

Leaving the other cells in the "Campaign Launch" column empty tells Google Sheets to ignore them when plotting, resulting in just a single, floating point. This setup is the foundation of the entire process.

Step-by-Step: Adding and Customizing Your Point

With your data structured correctly, creating the chart is a breeze. Let's walk through the exact steps.

Step 1: Create a Combo Chart

First, create the chart using all three columns. Don't just select the first two, make sure your new "single point" column is included in the selection.

1. Highlight the entire data range, including the headers (e.g., A1:C15).
2. Go to the menu and click Insert > Chart.

Google Sheets will usually create a Combo Chart by default when it detects this data structure. It will plot the main "Sessions" data as a line and the "Campaign Launch" point as a bar. If it doesn't, you can easily change it:

1. In the Chart editor pane that appears on the right, navigate to the Setup tab.
2. Change the Chart type to Combo Chart.

You should now see something like this: a line graph with a single, skinny bar poking up to mark your event.

![A combo chart in Google Sheets showing website sessions as a line and a campaign launch event as a single vertical bar.]

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: Customize the Point's Appearance

A tall, skinny bar gets the job done, but we can make it look much better. We want a distinct point, not a bar. This is where customization comes in.

1. In the Chart editor, switch to the Customize tab.
2. Expand the Series section.
3. You'll see a dropdown menu that says "Apply to all series." Click it and select your event series (e.g., "Campaign Launch"). Now, any changes you make will only apply to that single point.

Now, let's turn that bar into a point:

• Change the Color: Pick a color that stands out from your primary line graph color. A bright red or orange works well.
• Adjust the Point Properties: Find the options for "Point size" and "Point shape." Change the size to something larger, like 10px or 14px. You can also change the shape from a circle to a star, triangle, or diamond for extra emphasis.

After adjusting, your chart might still show both a bar and a point. To hide the bar, find the "Format" section in the chart editor (usually when the bar is selected or under Series settings with the event selected) and set the 'Type' from Columns/Bars to just 'Line'. Then set the line thickness to 0 or point size to your desired size with no line. But Sheets often simplifies this: customizing the point size and shape on a Combo Chart just replaces the bar entirely with your custom point.

Customizing the Series

[Image: The chart editor's customize panel, showing how to change the color and point size for the specific event series in Google Sheets.]

Step 3: Add a Data Label for Context

A highlighted dot is good, but a labeled dot is even better. People shouldn't have to guess what your special point means.

1. With your "Campaign Launch" series still selected in the Customize > Series menu, scroll down until you see a checkbox for Data labels. Click it.
2. A label will appear on your point. By default, it will show the Y-axis value (e.g., "3,101").
3. You can customize the label's font, size, color, and position to ensure it's easy to read. Positioning it Above the point usually looks cleanest.

And there you have it. Your final chart now clearly shows the daily trend with a well-defined, labeled point calling out exactly when your campaign started.

Final Chart with Customized Point

[Image: The final chart showing a line graph with a large, colored, and labeled point indicating the campaign launch date.]

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

Advanced Tip: Adding Multiple, Different Types of Points

What if you have more than one event to highlight? For instance, what if you want to show the campaign launch in green and a day of site maintenance (which caused a dip) in red?

You can't do this with a single extra column, because all points in one series share the same formatting. The solution is simple: create more columns!

You'd structure your data like this, with a separate column for each type of event:

Data for Multiple, Differentiated Events

[Image: Google Sheets table with four columns, one for each series, including columns for positive (Campaign Launch) and negative (Site Outage) events for your chart.]

When you create the combo chart now, Google Sheets will create three series: "Sessions," "Campaign Launch," and "Site Outage." You can then go into the Customize > Series menu and format each event series independently — making the campaign launch point a large green star and the site outage point a cautionary red triangle, for example.

Final Thoughts

Adding a single point to a graph in Google Sheets is a simple, effective storytelling device. It boils down to creating a separate column for your special event, letting that column serve as a new data series, and then customizing its appearance in a combo chart until it stands out. This small tweak can instantly add a layer of crucial context to your reporting.

While mastering these tricks in spreadsheets is valuable, it can still feel like a chore — especially when you have dozens of reports to build. At Graphed, we made this process as simple as asking a question. Instead of manually structuring data and tweaking settings, you just connect your sources and ask things like, "Show me website traffic this month and highlight the day our Black Friday campaign started." We instantly generate a live, interactive dashboard that does the work for you, freeing you up to focus on the insights, not the setup.