What Is a Data Point in Excel? (2026 Guide)

Open any Excel chart, click once on a column, and you select the whole series. Click a second time on the same column, and you select just that one bar. That single bar is a data point, and the moment you understand the difference between those two clicks, a large amount of chart formatting that previously felt random starts to make sense.

The term gets used loosely. People say "data point" to mean a cell, a row, a record, or a number in a report. In Excel specifically it has a narrower and more useful meaning, and that meaning is what determines which formatting options appear in the ribbon and which ones stay greyed out.

What Is a Data Point in Excel?

A data point in Excel is a single plotted value inside a chart series. It is the individual column, bar, slice, marker, or bubble that represents one number from your source range.

Every chart is built from series, and every series is built from data points. If you chart monthly revenue for a year, you have one series called Revenue and twelve data points inside it, one per month. Each of those twelve values has its own position on the chart and can carry its own colour, label, and border independent of the other eleven.

The important consequence is that Excel treats a data point as a formattable object in its own right. You are not limited to styling the whole series. You can pick out the one month that missed target, turn it red, and leave the other eleven alone, without touching the underlying data at all.

This is also why Excel's selection behaviour works the way it does. One click selects the parent series. A second click on the same element drills down into the individual data point. The ribbon and the formatting pane change to match whichever level you currently have selected.

Turning spreadsheet data into decisions your team actually acts on? Get a free SEO Stuff audit and we will look at how your reporting connects to results.

How Data Points Work Inside an Excel Chart

Understanding the object hierarchy makes everything else easier. Excel charts nest objects inside other objects, and data points sit near the bottom of that stack.

Data Points vs Data Series

A data series is the whole set of related values, usually one column or row from your source range. A data point is one member of that set.

In a clustered column chart comparing 2025 and 2026 sales across four quarters, you have two series and eight data points. Formatting the series changes all four of its columns at once. Formatting a data point changes exactly one column.

Series-level formatting is what you want for consistent branding. Point-level formatting is what you want for emphasis, exceptions, and annotation.

Data Points vs Cells

A cell is a storage location in the worksheet grid. A data point is a visual representation of a value in a chart. They are linked but not the same thing.

Change the number in cell B7 and the corresponding data point moves. Change the colour of the data point and cell B7 is completely unaffected. Chart formatting lives in the chart object, not in the worksheet.

This separation matters when you share files. Someone who copies your numbers into a new sheet gets the values but none of your point-level highlighting, because that formatting never lived in the cells.

How Excel Identifies a Data Point

Internally, Excel identifies each data point by its index position within the series rather than by its cell address. The first value in the series is point one, the second is point two, and so on.

That indexing explains a behaviour that surprises people: if you insert a row in the middle of your source range, custom formatting applied to individual points can shift onto neighbouring values, because the index positions have moved. The colour stays attached to position three, not to the value that used to be there.

How to Select and Format a Single Data Point

Selecting one point out of a series is a two-click operation, and getting the clicks right is most of the battle.

1. Click your chart once to activate it.
2. Click any column, bar, marker, or slice in the series you want. All members of that series are now selected, shown by handles on every one of them.
3. Pause for a moment, then click again on just the one element you want. Do not double-click, which opens the formatting pane on the series instead.
4. Check the selection handles. Only the single element should now show them.
5. Right-click that element and choose "Format Data Point". The pane header should read Format Data Point, not Format Data Series.
6. Open Fill and Line in the pane and set a solid fill colour for emphasis.
7. Add a border under Border if you want the point to stand out further.
8. Click away from the chart to deselect and confirm the result.

If the pane still says Format Data Series, your second click did not register as a separate click. Wait slightly longer between the two clicks and try again.

The same two-click rule applies to pie slices, line markers, and bubbles. It is the single selection technique that unlocks point-level formatting across every chart type Excel supports.

How to Add Labels to Individual Data Points

Data labels can be added to a whole series or to one point, and the second option is far less well known.

1. Select the individual data point using the two-click method above.
2. Click the plus icon at the top right of the chart to open Chart Elements.
3. Hover over Data Labels and click the arrow that appears.
4. Choose a label position such as Outside End or Center.

Excel adds a label to only the selected point. You can then click that label and type over it with your own text, which is the cleanest way to annotate a single anomaly without cluttering the rest of the chart.

Typed-over labels are static text, so they will not update if the underlying value changes. Use them for commentary, not for the number itself.

Reporting on performance data every month and not sure the story is landing? Get a free SEO Stuff audit and we will review the whole measurement setup.

When Individual Data Points Matter

Most charts never need point-level work. A handful of situations make it genuinely valuable.

The first is exception highlighting. One month that missed forecast, one product that outsold everything else, one week when a site migration tanked traffic. Colouring that single point turns a chart people scan into a chart people read.

The second is forecast versus actual. Many teams shade projected future points differently from historical ones, often with a lighter fill or a dashed border, so nobody mistakes a model output for a measurement.

The third is annotation. A chart with one labelled point and a short note carries more meaning than a chart with every value labelled, because the label directs attention rather than competing for it.

The fourth is accessibility. Where colour alone carries the distinction, point-level borders and markers give readers a second visual cue that survives greyscale printing and colour-blindness.

Not sure which numbers in your reporting deserve the spotlight? Get a free SEO Stuff audit and we will help you separate signal from noise.

Limitations and Common Problems

Point-level formatting is powerful and slightly fragile. These are the failure modes worth knowing before you rely on it.

Formatting Breaks When Data Shifts

Because Excel tracks points by index, inserting or deleting rows in the source range moves your custom formatting onto different values. Always apply point-level formatting last, after the data range is final.

If your range grows regularly, consider using a conditional helper series instead. Build a second series that contains the value only when a condition is met and blanks otherwise, then format that whole series once. It survives data changes because the logic lives in formulas.

Too Many Points Makes the Chart Unreadable

Excel will happily plot thousands of points, but a line chart with two thousand markers is a solid smear. Scatter and line charts degrade well without markers; column charts do not.

As a rough rule, drop markers above about fifty points, and consider aggregating to a coarser time period above a few hundred. The goal is a readable trend, not a complete record.

Blank Cells Create Gaps

An empty cell in the source range does not plot as zero. It creates a gap in a line, a missing column, or a broken series depending on chart type.

Control this through Select Data, then Hidden and Empty Cells, where you can choose to show blanks as gaps, as zero, or to connect the line across them. Each choice tells a different story, so pick deliberately rather than leaving the default.

Copied Charts Keep Old Formatting

Duplicate a chart and point it at a new range, and any point-level formatting comes along for the ride, still attached to the same index positions. Reset it under Format Data Point by clicking "Reset to Match Style" before repointing.

Data Points vs Related Terms

The word gets stretched across several meanings. Keeping them separate avoids confusion when reading documentation or talking to colleagues.

Data Point vs Data Marker

Microsoft's own documentation sometimes uses "data marker" for the visual shape and "data point" for the value it represents. In everyday use the two are interchangeable, and Excel's interface says data point.

Data Point vs Observation

In statistics an observation is a full record with several variables, while a data point in Excel is a single plotted value. One statistical observation with four measured variables can produce four Excel data points across four series.

Data Point vs Cell Value

A cell value is the stored number. A data point is that number once plotted. Every plotted data point has a source cell, but plenty of cell values are never plotted at all.

Excel vs Google Sheets

Google Sheets supports point-level formatting too, but it is buried in the chart editor under Series, then individual point overrides, and the selection behaviour is less direct. Excel's two-click drilldown remains the faster workflow for anyone doing this often.

Final Thoughts

A data point in Excel is simply one plotted value inside a series, but the definition carries a practical payoff: it is the level at which you can highlight, label, and annotate a single number without disturbing anything else on the chart. Master the two-click selection, apply point-level formatting only once your data range is settled, and remember that Excel tracks points by position rather than by cell. If you want to go a level up and get the source side right first, our guide on what a data range is in Excel covers how Excel decides what to plot in the first place.

Ready to make your data work harder for organic growth? Get a free SEO Stuff audit and we will show you where the opportunity sits.