Excel Scatter Plot: How to Change Dot Size and Scale

To change dot size in an Excel scatter plot, select a marker, open Format Data Series, then choose Fill & Line > Marker > Marker Options > Built-in and adjust Size. That changes the markers for the selected series; you can format one data point separately when you need to highlight it.

Change the size of every dot in a series

In Excel for Microsoft 365 on Windows, use these steps:

Click a dot in the scatter plot once. This selects the whole data series, not just that one point.
Right-click the selected series and choose Format Data Series. You can also press Ctrl+1 after selecting the series to open its formatting pane.
In the pane, select Fill & Line (the paint-bucket icon), expand Marker, and open Marker Options.
Choose Built-in if it is not already selected, then enter or adjust a value under Size.

The markers update as you change the size. If you have several series, repeat these steps for each one: marker size is a series-level setting, so changing one series does not automatically resize the others. To close the pane, select its close button or click back into the worksheet.

On Excel for Mac, select the series, open its formatting pane from the contextual chart-formatting controls or the right-click menu, and find the same Marker Options and Size controls. The pane’s appearance and ribbon layout can differ slightly by Excel version. Excel for the web may offer fewer formatting controls; if you cannot find Marker Options, open the workbook in the desktop app.

What the marker-size setting changes

A scatter chart plots numerical X and Y values as points. The Marker Size control changes the visual diameter of the symbols used to show those points; it does not change the values in the worksheet, move any points, alter either axis, or change the chart’s scale. A larger marker can make points easier to see, but it can also cover nearby points and make a dense chart harder to interpret.

Excel’s built-in marker choices include shapes such as circles, squares, diamonds, and triangles. The selected size applies to the built-in markers in that series. In the same Marker section, you can change the marker shape, choose no marker, and adjust marker fill and border. Those settings affect appearance, while the underlying coordinates remain the same.

Marker size is not the same as the size of the plot area or the chart itself. If you enlarge the chart by dragging its handles, the chart occupies more space, but the marker-size setting does not necessarily change. Conversely, increasing marker size makes the dots larger within the existing plot area without expanding the chart.

Choose a size that fits the chart

There is no universally correct marker size. The useful setting depends on how many points are plotted, how close they are, the chart’s physical dimensions, and whether the chart will be read on screen or printed. Start with a moderate size, then check the result at the size readers will actually see it.

Few, widely spaced points: Moderately larger markers can make individual observations easier to identify.
Many points in a small area: Use smaller markers so less of the plot is hidden. Transparency can also help reveal overlapping points.
Presentation or report: Make markers large enough to remain visible after the chart is resized or printed, and check that they do not obscure axis labels or nearby data.
Several series: Use marker shapes or colors as well as size to distinguish groups. A size difference alone can imply a difference in value that the data may not support.

For example, a plot of 12 measurements may remain clear with medium-sized circles. If the same chart contains 1,200 observations, those circles may merge into a solid patch. Reducing the markers, adding transparency, or displaying fewer points can reveal the distribution more honestly. Test changes against the densest part of the chart rather than judging only the isolated points.

Resize one data point to emphasize it

Excel can format an individual point without changing the rest of its series. First click a marker once to select the series. Then click the target marker again, carefully, so only that data point is selected. Right-click and choose Format Data Point; in the formatting pane, open Fill & Line > Marker > Marker Options and set its built-in marker size.

Selection can be fiddly when points overlap. If a click keeps selecting the full series, click the point again or use the chart’s Format tab and its Current Selection controls to locate the intended chart element, where available. The pane title is a useful check: it should identify a data point rather than the whole data series before you make a point-specific change.

Individual formatting is useful for calling out an outlier, a target measurement, or a particular observation. Keep the distinction meaningful: a larger highlighted dot should be explained in a legend, label, or nearby note if readers might otherwise assume its size represents another numeric variable. Point-level formatting is also manual. If the highlighted observation changes when the data is updated, review the chart and reapply the emphasis to the correct point.

Size differences versus data-driven bubbles

A common question is whether a scatter plot can assign a different marker size to each row based on a third column. The ordinary scatter chart’s Marker Size control is a formatting setting for a series or an individually formatted point; it does not automatically map a worksheet column to marker size. Changing the series size therefore makes its markers larger or smaller together.

When each observation has three meaningful numeric values, consider a bubble chart. A bubble chart uses horizontal position for one value, vertical position for another, and bubble size for a third. To create one, arrange the data with X values, Y values, and bubble-size values in separate columns, select the relevant data, and insert a Bubble chart from Insert > Insert Scatter (X, Y) or Bubble Chart. Review the resulting series and its size settings because the third column must be assigned as bubble-size data.

Bubble charts are not simply scatter plots with bigger dots. Readers compare area imperfectly, so small differences in bubble size can be difficult to judge. Bubbles can also overlap and hide one another. Use this chart type only when the third variable matters, label or explain the size encoding, and avoid suggesting that marker size represents data if it is merely a visual styling choice.

Improve visibility without hiding information

If dots are hard to see, size is only one possible adjustment. A strong fill color, a contrasting outline, or a different marker shape may improve visibility without making symbols so large that they cover neighboring values. Select the series and use its Format Data Series pane to adjust marker fill and border as well as size. A hollow marker can be useful where points overlap because the area inside the symbol remains visible.

For overlapping observations, transparency can make stacked markers easier to detect. In the marker fill options, choose a solid fill and adjust its transparency if that control is available in your Excel version. Use enough contrast for the chart background and avoid relying on color alone to distinguish series; shapes, labels, or a clear legend provide additional cues. If many observations share identical coordinates, making the dots larger will not reveal how many points sit underneath. Consider explaining the overlap or using a different chart design.

Also check the axis range and chart dimensions before concluding that the markers are too small. A very broad axis range can bunch values into a narrow region, while a cramped chart can make even reasonable markers look crowded. Adjusting the data display or enlarging the plot area may solve the readability issue more effectively than increasing every dot.

Common problems and how to fix them

The Size control is missing: Confirm that a data series is selected and that you are in its formatting pane. Expand Marker and Marker Options; the control is not part of the axis-formatting options.
Only one series changes: That is expected. Select each series separately if you want consistent marker sizes across the chart.
The whole series changes when you meant one dot: The series is selected. Click the desired point a second time and confirm the pane identifies a data point before changing its formatting.
Dots disappear after choosing a marker option: Check that markers are not set to None. Choose Built-in and select a shape and size.
Large dots look clipped or overlap the chart edge: Reduce the size or allow more room around the plot area. A marker centered near an axis boundary can extend beyond the visible plotting region.
The chart changes after refreshing or replacing data: Recheck any individually formatted points and series settings. Data edits can change which observation occupies a particular position.

If a right-click menu does not show the expected command, make sure you clicked a marker rather than the chart background, axis, or legend. Selecting the chart element first and then using Format Selection on the contextual Format tab is another way to open the appropriate pane.

Frequently Asked Questions

Can I change the size of all dots at once?
Yes, if the dots belong to one series: select that series and change Marker Options > Built-in > Size. Repeat for each separate series in the chart.

Can Excel size each scatter-plot dot from a cell value?
Not with the ordinary scatter-series marker-size setting. Use a bubble chart when a third numeric column should determine the size of each observation’s bubble.

Does changing dot size change the data or axes?
No. It changes the markers’ visual appearance only. The plotted X and Y values and the axis scales remain unchanged.

Can I make just one dot bigger?
Yes. Select the series with one click, select the individual point with a second click, then format that data point’s marker size. Verify that the pane refers to the point, not the series.

Why do my dots overlap even after I change their size?
Points with identical or nearby coordinates can occupy the same area. Smaller markers or transparency may expose some overlap, but a marker-size change cannot separate points with the same coordinates.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.