Vertical Scatter Plot in Excel: How to Create One

How-to basics · Updated November 21, 2026

To make a vertical scatter plot in Excel, put the same X value beside each observation, select the X and Y columns, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter with Only Markers. Excel plots the observations at their Y values along a vertical line; you can then format the axes and add labels to make the chart useful.

What a vertical scatter plot shows

An Excel scatter chart, also called an XY chart, positions each point using two numeric values: X determines its horizontal location and Y determines its vertical location. A vertical scatter plot is not a separate chart type. It is an XY scatter chart in which all the points share one X value, so they line up vertically. For example, one fixed X value could place several people’s heights, test scores, or measurement readings on the same line.

This is useful when the main interest is the distribution of values rather than a relationship between two changing measurements. A vertical line of points can show the range, clusters, gaps, and unusually high or low observations more directly than a list of numbers. The shared X position is a plotting device, not an extra measurement: if it represents a real measured variable, assigning it the same value to every record would hide variation that might matter.

People also use “vertical scatter plot” to mean a scatter chart with the usual vertical Y axis, even when X varies. In that case, create an ordinary XY scatter chart with the real X and Y values; do not make the X values identical. The instructions below explain the single-line version and note how to adapt it when comparing groups.

Prepare the worksheet data

Use one row per observation and separate columns for its label, X position, and measured value. For example, a small sample of six reading times could be arranged as follows. The labels identify the observations; the repeated X value puts them on one vertical line.

  • Label: Reading 1 through Reading 6.
  • X position: 1 in every row.
  • Reading (Y): 12, 15, 15, 18, 21, and 24.

Put headers in the first row, such as Label, X position, and Reading. Store the X positions and readings as numbers, not numbers typed as text. A blank cell is not a zero, and a text value such as “18 min” may not plot as the numeric value 18. Keep units in the column heading or chart title—for instance, Reading time (minutes)—rather than appending them to each number.

For this simple chart, select only the X position and Reading columns, including their headers. If the columns are next to each other, select the two-column range. If they are separated, select the X range and then use Ctrl-click to add the Y range on Windows; on Mac, use Command-click. Because nonadjacent selection can be awkward, placing the two numeric columns next to one another is often easier. The label column can be used later for point labels.

Create the chart in Excel for Microsoft 365

  1. Select the X position and Reading data, including the column headings but not the Label column.
  2. On the ribbon, choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter with Only Markers. In some ribbon layouts the chart button is shown as a scatter-chart icon; open its menu and choose the option with markers and no connecting lines.
  3. Excel inserts an XY scatter chart. Check that the horizontal axis uses the X position values and the vertical axis uses the readings. If Excel has arranged the series incorrectly, right-click the chart, choose Select Data, select the series, and choose Edit to set the series X values and series Y values to the correct cell ranges.
  4. Move or resize the chart, then add useful titles. Select the chart and use Chart Design > Add Chart Element > Chart Title or Axis Titles. A chart title such as Reading times for six samples and a Y-axis title such as Minutes explain what the points mean.

In current Excel for Mac, the same basic XY chart is available from the Insert tab’s scatter-chart menu, although ribbon layout and some formatting-pane labels can differ. Excel for the web also offers scatter charts, but some detailed formatting and labeling controls may vary from the Windows desktop app. The steps here use Microsoft 365 for Windows.

Format the vertical line and axes

When all X values are 1, Excel chooses horizontal-axis bounds automatically. The line may appear near the center, or the axis may have more space than the chart needs. To control that space, right-click the horizontal axis and choose Format Axis. In the Format Axis pane, open Axis Options and enter appropriate values under Bounds. For a single line at X = 1, bounds such as 0.5 and 1.5 can center the points, provided those bounds are suitable for the chart. These are display limits, not changes to the source data.

The vertical axis should reflect the values and units being shown. Use Format Axis to adjust its minimum and maximum when automatic limits make comparisons hard to read. Avoid narrowing the range in a way that exaggerates small differences without making the scale clear. If zero is not meaningful for the measurement, the axis does not always need to start at zero, but readers should be able to see the displayed bounds.

To make the markers easier to distinguish from the gridlines, select a point and use Format Data Series to change marker size, fill, or border. A modest marker size is usually clearer than oversized dots. You can also reduce unnecessary gridlines, keep a plain background, and use a descriptive chart title. In a small chart, too many decorative elements compete with the data rather than clarifying it.

Add observation labels and handle overlap

Labels can identify which observation produced each point. Select the plotted series, then use Chart Design > Add Chart Element > Data Labels > More Data Label Options. In the Format Data Labels pane, select Value From Cells and choose the label cells, such as the six entries in the Label column. Clear Y Value if you want names without repeating the measurement next to every marker. If Value From Cells is not available in your Excel build, you can label points manually, but those labels may need updating when the data changes.

Labels are most helpful when there are only a few points or when individual records matter. With many observations, labels can overlap and turn the chart into a block of text. Use a smaller sample, label only notable points, or retain the labels in a nearby table instead. A legend is not a substitute for point labels when every observation belongs to the same data series.

Repeated Y values create another kind of overlap: two records with the same reading and same X position land on the exact same point. The chart may look as if one record is missing. If the purpose is to show how many records share a value, consider a histogram or another frequency display. If you need to see individual records, a small horizontal offset for plotting can separate the markers, but it changes their visual X positions. Treat that offset as a display aid, document it, and do not interpret it as measured X variation.

Show several groups in a vertical dot plot

To compare categories such as departments, treatments, or locations, give each group its own numeric X position. For example, set all observations in Group A to X = 1, Group B to X = 2, and Group C to X = 3; use the measurement as Y. Add each group as a separate series, or use one series with X values assigned by group. Then format the horizontal axis so its tick marks correspond to the group positions. A conventional numeric axis will show 1, 2, and 3; category names can be supplied through labels or placed in nearby cells.

When multiple points in the same group have identical or similar readings, they may overlap. A small, deliberate horizontal jitter can reveal repeated observations, but it should be applied only to the plotting positions—not to the original measurements—and described so readers know the offsets have no analytical meaning. For clean group comparisons, use the same vertical-axis scale across groups. Changing the scale from one group to another can make equal values appear different.

If the X position is a genuine numeric measure, preserve its actual value rather than replacing it with a group number. A scatter chart is designed to show numeric spacing: X values 1 and 2 are one unit apart, while 2 and 10 are eight units apart. That behavior differs from a category chart, where labels are normally spaced evenly regardless of their numeric-looking text.

Choose between a scatter plot and other charts

A vertical XY scatter chart is appropriate when the observations are numeric and you want their exact positions, especially when X is a real measurement or when points must be compared across groups. It is also a practical way to build a simple dot plot for one set of values, although Excel does not provide a dedicated chart type named vertical scatter plot.

A column chart is usually better for comparing totals, averages, or counts across named categories. A histogram is better for showing how many observations fall into numeric intervals, rather than identifying each observation. A box-and-whisker chart summarizes distribution features such as the median and quartiles; it does not display every observation by default. Those charts answer different questions, so choose based on whether the reader needs individual values, category summaries, or distribution shape.

A common misconception is that a vertical scatter plot is the same as a bar chart turned sideways. It is not: scatter charts place points according to two numeric axes, while bar and column charts encode values as bar lengths and use categories. Another misconception is that connecting scatter points makes a more complete chart. Connect points only when their order has meaning, such as a time sequence; otherwise, a line can imply a continuous path between unrelated observations.

Common problems and quick checks

  • Points appear as one dot: Check whether both X and Y values are identical, or whether repeated observations overlap. Add meaningful labels or choose a frequency-focused chart if duplicates are the story.
  • The points run horizontally: Verify that the measurement column is assigned as Y values and the repeated position column as X values in Select Data > Edit.
  • Excel shows a blank chart: Confirm that the selected ranges contain numeric values and that the series ranges have matching numbers of rows. Check for numbers stored as text.
  • The X axis shows unexpected limits: Inspect Format Axis > Axis Options > Bounds. Automatic bounds can change when the data changes, while manually set bounds may hide new points outside the selected range.
  • Labels are crowded: Remove labels that are not essential, enlarge the chart, or use a table to identify observations. Do not shrink text until it is unreadable.
  • Markers are joined by lines: Choose Scatter with Only Markers, or change the series to that subtype. Use connecting lines only when the order of the observations carries meaning.

Before sharing the workbook, check that the chart title, axis units, and displayed scale explain the data without relying on the worksheet layout. Also check that any visual jitter is disclosed and that manually selected axis bounds do not omit observations. These checks help prevent a technically correct chart from suggesting the wrong conclusion.

Frequently Asked Questions

Can Excel make a vertical scatter plot?
Yes. Insert an XY scatter chart and assign the same numeric X value to every observation while using the measurements as Y values. Excel does not list “vertical scatter plot” as a distinct chart type.

How do I make a vertical line of dots in Excel?
Put a repeated X value, such as 1, beside each measurement. Select those X values and the measurement column, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter with Only Markers.

Why are some points missing from my scatter plot?
They may be directly underneath another marker because they share the same X and Y values. Add point labels, use a suitable frequency chart, or apply a clearly documented plotting offset if showing each record is essential.

Can I use text categories on the horizontal axis?
An XY scatter chart requires numeric X positions. Assign numbers to the categories, then identify those positions with labels or explanatory text. If you need a standard text category axis, a column or line chart may suit the task better.

Should I connect the points?
Usually not when each dot is an independent observation. Connecting points can imply an order or continuous change that may not exist. Use lines when the sequence is meaningful, such as measurements taken over time.

Related

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.