How Do You Plot Points on a Graph in Excel? (2026 Guide)

Most people who want to plot points on a graph in Excel reach for Insert, then Line chart, and end up with something wrong. The line appears, the shape looks roughly right, but the horizontal positions are evenly spaced regardless of what the numbers actually say. A point at x=1 and a point at x=100 sit the same distance apart as a point at x=1 and a point at x=2.

The fix is a single chart type, and once you know which one it is, the whole thing takes about thirty seconds. The trouble is that Excel's chart menu does not explain the distinction anywhere, and the two options look nearly identical in the preview.

This guide covers the chart type you actually need, the exact steps to plot a set of coordinate pairs, how to label individual points, and the handful of formatting changes that turn a default Excel scatter into something readable.

How Do You Plot Points on a Graph in Excel?

Select your two columns of data, then go to Insert, Charts, and choose Scatter (also called XY Scatter). Pick the first variant, "Scatter with only Markers." Excel will read the left column as X values and the right column as Y values, and place one dot per row at its true coordinate position.

That is the whole answer. The chart type is Scatter, not Line.

The distinction matters more than it sounds. A Line chart treats your first column as category labels, which means it spaces them evenly along the axis no matter what values they contain. A Scatter chart treats that column as numbers and positions each point according to its actual value. If your X values are measurements, times, dosages, distances or anything else continuous, you need Scatter.

If your points come out in a straight diagonal line when they should not, that is the symptom of using the wrong chart type. Excel has plotted them in row order rather than by value.

Wondering how your data pages look to search engines? Get a free SEO audit and see what is working.

Why Excel Has Two Chart Types That Look the Same

The Line Chart Treats X as a Label

A Line chart in Excel expects one column of categories and one or more columns of values. The categories can be text, dates, or numbers, and Excel does not care which. It places them along the horizontal axis in the order they appear, evenly spaced.

This is exactly right for monthly sales, where every gap between categories represents the same unit of time. It is exactly wrong for a set of measurements taken at irregular intervals, because the graph will misrepresent the spacing.

The Scatter Chart Treats X as a Number

A Scatter chart expects two columns of numbers. It reads the first as an X coordinate and the second as a Y coordinate, then places a marker at that position on a genuine numeric plane.

Both axes are numeric and independent. You can have points at x=0.5, x=2, and x=97 in the same series, and they will sit at their correct relative distances. The order of your rows makes no difference to where anything appears.

How to Tell Which One You Need

Ask whether the horizontal axis represents a measurement or a label. If the values along the bottom are quantities you could do arithmetic on, and the gaps between them carry meaning, use Scatter. If they are names, categories, or evenly spaced periods, a Line chart is fine.

One more test: if you sorted your data differently, would the graph change shape? With a Line chart it would. With a Scatter chart it would not. That difference tells you which one is representing your data honestly.

How to Plot Your Points: Step by Step

Step 1 — Lay Out the Data in Two Columns

Put your X values in one column and your Y values in the column immediately to its right. Excel assumes left is X and right is Y, so the order matters.

Give each column a header. Excel will use those headers for the series name and the axis titles later, which saves you typing them in by hand.

Leave no blank rows in the middle of the range. A gap will either split your series or produce a break in the plot, depending on your settings.

Step 2 — Select the Range and Insert the Chart

Highlight both columns including the headers. Go to the Insert tab, find the Charts group, and click the scatter chart icon, which looks like a small cluster of dots.

From the dropdown, choose the first option, "Scatter with only Markers." The other variants add connecting lines, smooth curves, or both. Start with markers only and add lines later if you decide you want them.

Excel drops the chart onto the worksheet immediately. At this stage it is functional but plain.

Step 3 — Fix the Axes

Excel picks axis ranges automatically, and its choices are often poor. Right-click the horizontal axis and choose Format Axis to set the minimum and maximum yourself.

The default minimum is frequently zero even when your data starts at 500, which squashes all your points into the top corner. Setting a sensible minimum usually improves the chart more than any other single change.

While you are there, check the major unit. Excel sometimes chooses intervals like 0.7 or 33, which make the axis hard to read. Round numbers work better.

Want to know which of your pages actually rank? Run a free audit and find out.

Step 4 — Add Axis Titles and a Chart Title

Click the chart, then the plus icon that appears at its top right. Tick Axis Titles and type what each axis represents, including units.

A scatter plot without axis labels is close to useless to anyone who did not build it. This is the step people skip and then regret when the chart ends up in a report.

Replace the default chart title with something that states what the graph shows rather than repeating the column header.

Step 5 — Make the Markers Readable

The default Excel marker is small and often a shade of blue that disappears against gridlines. Right-click any point, choose Format Data Series, then Marker Options.

Increase the size to somewhere between 7 and 10 points. Pick a solid fill with a contrasting border. If you have overlapping points, reduce the fill transparency so density becomes visible.

How to Label Individual Points

Labelling each point with its name is the request that follows almost immediately after plotting, and Excel makes it more awkward than it should be.

Right-click any marker and choose Add Data Labels. By default Excel shows the Y value, which is rarely what you want.

To show custom text instead, right-click the labels, choose Format Data Labels, untick Y Value, and tick "Value From Cells." Excel will ask for a range. Point it at the column containing your labels, and each point picks up the text from its own row.

This option has existed since Excel 2013 and is the only clean way to do it. Before that, people labelled points one at a time by hand, which is still what many older tutorials describe.

If the labels collide with each other, drag individual ones to reposition them. Excel remembers manual positions per label, so you only have to do it once.

A quicker route for a handful of points is to set the label position to the right or above for the whole series first, then only move the two or three that still overlap. Blanket positioning solves most collisions in one click.

Keep the label text short. A scatter plot labelled with full product names or long descriptions turns into a wall of text, and the points themselves disappear behind it. Abbreviate in a helper column and point the labels at that instead.

When a Scatter Plot Is the Right Choice

Scatter plots earn their place when you are looking for a relationship between two numeric variables rather than tracking one variable over time.

Use one when you want to see whether two things move together, where the outliers sit, how tightly the points cluster around a trend, or whether your data splits into distinct groups. All of these are questions about shape, and shape is what a scatter plot shows better than any other chart type.

Adding a trendline makes the relationship explicit. Right-click a point, choose Add Trendline, and pick linear unless you have a reason to expect a curve. Tick "Display R-squared value" and Excel will tell you how well the line fits.

Treat that R-squared figure carefully. It tells you how closely the points hug the line, not whether one variable causes the other, and a high value on a small sample is easy to produce by accident.

Outliers deserve attention before you draw any conclusion from the shape. A single stray point can drag a trendline noticeably, so it is worth checking whether the odd one out is a real observation or a typo in the source data.

For a small number of points with meaningful labels, a scatter plot doubles as a positioning map. Two axes, a dozen labelled points, and you have a quadrant chart of the kind used for competitive comparisons. Our guide to building a four-quadrant graph in Excel covers that variant in full.

Curious what your competitors rank for? Get your free SEO audit and compare.

Where Scatter Plots Fall Down

They get crowded fast. Past a few hundred points, markers overlap into a solid mass and you lose the density information that made the chart worth building. Transparency helps, and so does reducing marker size, but at some point a different chart type is the honest answer.

They handle only two variables cleanly. You can encode a third with marker size, which turns it into a bubble chart, but that is the practical ceiling. Anything more and the chart becomes a puzzle.

Excel's scatter chart also struggles with dates on the X axis. It will accept them, because dates are stored as numbers underneath, but the axis labels come out as serial numbers unless you format them back to dates manually.

The workaround is to select the horizontal axis, open Format Axis, and apply a date number format directly. The positions were always correct; only the labels were wrong.

And multiple series on one scatter plot need careful marker differentiation. Excel's default colour sequence is not always distinguishable, particularly when printed in greyscale. Change the marker shapes as well as the colours.

Not sure which pages are pulling their weight? Get a free SEO audit and see the numbers.

Scatter Plot vs the Alternatives

Against a Line chart, the difference is the one covered above: Line treats X as a category, Scatter treats it as a number. If your X values are irregular, Scatter is not a stylistic preference, it is the only correct option.

Against a Bubble chart, the difference is a third variable. A bubble chart is a scatter plot where marker size carries data. Use it when you genuinely have a third quantity worth showing, and not otherwise, because size is hard to read precisely.

Against a Column chart, the question is whether your categories are discrete. Comparing five products is a column chart. Comparing five hundred measurements is a scatter plot.

If your goal is showing the composition of a total rather than a relationship, none of these are right. That is territory for a stacked bar chart instead.

Final Thoughts

Plotting points on a graph in Excel comes down to choosing Scatter rather than Line, and then fixing the four things Excel gets wrong by default: the axis ranges, the missing axis titles, the undersized markers, and the data labels showing values instead of names.

The chart type is the part that matters. Everything else is formatting you can adjust afterwards, but a Line chart pretending to be a scatter plot will quietly misrepresent your data no matter how much you polish it.

If you take one habit away from this, make it the axis check. Look at the horizontal axis on any finished chart and confirm the spacing between values matches the spacing in your data. That single glance catches the most common Excel charting mistake there is.

If you are building charts to go into a report or dashboard, it is worth getting the underlying data structure right first. Our guide to pivot tables in Excel covers how to shape messy data into the tidy two-column format that charts actually want.