To customize a scatter plot axis in Excel for Microsoft 365 on Windows, select the chart, right-click the horizontal or vertical axis, and choose Format Axis. In the Format Axis pane, adjust its minimum and maximum bounds, major units, number format, scale, and where the axes cross; the exact controls depend on which axis you selected.
What makes a scatter plot axis different?
An Excel scatter chart, also called an XY chart, plots paired numeric values as coordinates. Each point has an X value and a Y value, so both axes represent numerical scales. This differs from a line chart, which typically places categories at evenly spaced positions along its horizontal axis—even when the category labels look like dates or numbers.
That distinction matters when values are unevenly spaced. For example, if measurements were taken after 1, 2, and 10 hours, a scatter chart places the third measurement farther from the second than the first two are from each other. A line chart may instead give the three observations equal spacing. Use a scatter chart when the horizontal values are measurements whose numeric spacing has meaning, such as time, distance, temperature, or concentration.
In a scatter chart, the horizontal axis is the X-value axis and the vertical axis is the Y-value axis. Excel may label a vertical axis with values that come from the second data column, but the chart does not treat that axis as a list of categories. Customizing the axis scale changes how coordinates are displayed; it does not change the underlying worksheet values.
Create or check the chart’s data series
Before changing an axis, make sure Excel is plotting the intended columns. A typical layout has one column of X values and one column of Y values, with a header row above them. Select the data and use Insert > Insert Scatter (X, Y) or Bubble Chart, then choose a scatter subtype. Markers only are useful for showing individual observations; lines or smooth lines can be added when connecting observations is meaningful.
If the chart already exists, select it and go to Chart Design > Select Data. In the Select Data Source dialog, choose a series and select Edit to inspect its series X values and series Y values. Check that both ranges contain the intended numeric observations, have matching lengths, and do not accidentally include header cells. A chart with the wrong X range can look like an axis-formatting problem even when the axis settings are correct.
- Keep X and Y values in separate, aligned ranges: each row should describe one plotted pair.
- Check for numbers stored as text, blank cells, or unexpected zeros if points are missing or positioned strangely.
- Use Chart Design > Add Chart Element to add axis titles when readers need to know the measured quantity and units.
Set minimum, maximum, and major units
To control the visible range, right-click the axis and choose Format Axis. In Axis Options, look for Bounds and Units. Enter a fixed minimum or maximum to replace Excel’s automatic choice. Set the major unit to control the spacing between major tick marks and their labels. For example, an axis running from 0 to 100 with a major unit of 20 displays major values at 0, 20, 40, 60, 80, and 100.
Suppose the X values cover 12 through 48, but the chart automatically starts at 0. Setting the minimum to 10 and the maximum to 50 can make variation across the observed range easier to see. The right choice depends on the question: showing zero can provide important context, while narrowing the range can make small differences more legible. If you fix bounds, verify that all relevant observations remain visible and make the chosen range clear to readers.
Excel may change the bounds or units back to Auto if you clear a field or choose an automatic setting. Fixed bounds are useful when you need consistent scales across several charts, such as comparing separate groups. They can also become misleading if later data falls outside the set range, so review them when the data changes.
Change tick marks, labels, and number formats
The Format Axis pane controls how the scale is presented as well as its range. Under Tick Marks, choose the tick-mark type for major or minor intervals, such as none, inside, outside, or cross, when those options are available for the selected axis. Under Labels, adjust the label position. These settings can reduce visual clutter, but removing labels entirely may make the chart harder to interpret.
To format displayed values, open the axis’s Number section. Choose a suitable category and decimal-place setting, or enter a format code, then apply it. Formatting affects the labels, not the stored values. For instance, a number format that displays one decimal place can show 2.3 while the underlying value remains more precise. If values represent percentages, currency, or measurement units, use a matching format and explain the units in the axis title when necessary.
Do not confuse axis number formatting with changing source data. If the values themselves need conversion—for example, from meters to kilometers—change or calculate the data appropriately and make the chart’s units explicit. Merely changing a number format does not convert a value of 1,000 meters into a value of 1 kilometer.
Choose where the axes cross
Axis crossing settings determine where the horizontal and vertical axes meet. In a scatter chart, the horizontal axis can cross the vertical axis at an automatic position or at a specified axis value. Depending on the selected axis and chart settings, Excel also offers options that position an axis at an extreme value. These controls are in Format Axis > Axis Options; wording and available choices can vary with the axis and chart.
Crossing at zero is often appropriate when zero is meaningful and included in the displayed range. If all X values are positive and the horizontal axis is set to cross at zero, the vertical axis may sit at the left edge of the chart. If the X range includes negative and positive values, crossing at zero places the vertical axis within the plot area. This can help show quadrants, but it may be less familiar to readers than axes along the chart edges.
Changing the crossing location does not change any plotted coordinate. It changes the position of the axis line and may affect where labels appear. If labels overlap points or become difficult to read, try a different crossing setting or label position, then check the result at the chart’s final size.
Use logarithmic and reversed scales carefully
A logarithmic axis can help display values that span several orders of magnitude. In Format Axis > Axis Options, select Logarithmic scale if the data and chart support it. Excel’s logarithmic scale requires positive values; zero and negative values cannot be plotted on that log axis. A logarithmic scale also changes the visual meaning of equal distances: equal intervals represent multiplicative changes rather than equal additions.
Use a log scale only when it suits the data and the reader can recognize it. Label the axis clearly and avoid presenting a log-scaled chart as if equal vertical or horizontal steps meant equal numeric differences. If the observations include zero or negative values, use a linear scale or choose another appropriate way to present the data.
The Values in reverse order option reverses an axis direction. It can be useful for a deliberate convention, but it can also make a chart counterintuitive because values increase in the opposite direction from what many readers expect. If you reverse an axis, make the direction obvious and inspect the crossing and label positions afterward; Excel may reposition them as part of the change.
Make scales comparable across charts
When two scatter charts are meant to be compared, matching their axis limits and major units makes visual comparisons fairer. If one chart starts at 0 and another starts at 40, the same difference can appear very different in size. Use fixed bounds in each chart and confirm that both axes use the same units and scale type. Matching only the chart dimensions is not enough if the numeric ranges differ.
There is a trade-off: a common scale may leave much of one chart’s plotting area unused, while separate scales can exaggerate or conceal differences between groups. Choose based on the comparison you want readers to make. If you use different ranges, state or visibly show them rather than expecting readers to infer the difference.
A secondary vertical axis is sometimes used when two series have very different units or ranges. It can make both series visible, but it can also suggest a relationship that depends on arbitrary scale choices. Consider separate charts or clearly labeled panels instead. If you do use a secondary axis, label both axes with their units and explain which series belongs to each scale. A secondary axis does not make unlike measurements directly comparable.
Common axis problems and how to fix them
- The axis begins at an unexpected value: Open Format Axis and inspect the minimum bound. If it is fixed, return it to Auto or enter the intended minimum.
- The chart shows category-like spacing: Confirm that the chart type is an XY scatter chart, not a line chart. Also check that the X values are in the series X values range.
- Points disappear after changing bounds: Check whether the fixed minimum or maximum excludes them. Widen the range or restore automatic bounds.
- Tick labels overlap: Increase the major unit, reduce decimal places, make the chart wider or taller, or reposition labels. Avoid removing context the reader needs.
- A log scale will not work: Look for zero or negative values in the plotted range. A logarithmic axis cannot display them.
- The scale changes after new data is added: Automatic bounds may adjust to include the new values. Fixed bounds stay consistent but may clip later observations, so check the chart after updating data.
Windows, Mac, and Excel for the web
The instructions here use Excel for Microsoft 365 on Windows. In the Windows desktop app, selecting the axis and pressing Ctrl+1 opens the Format Axis pane; right-clicking the axis and choosing Format Axis is another route. On Mac, select the axis and use Format > Format Selection or the contextual formatting controls available in the ribbon. The pane’s layout can differ, but axis bounds and scale options are generally in its axis options.
In Excel for the web, chart editing and formatting options may be more limited or arranged differently than in the desktop app, and availability can change as the service is updated. If you cannot find a specific axis control, open the workbook in the Excel desktop app to use the full formatting pane. On Mac, the Windows Ctrl+1 shortcut is not the equivalent; use the Mac interface or its available keyboard shortcuts rather than assuming Windows shortcuts apply.
Frequently Asked Questions
How do I change the X-axis scale in an Excel scatter plot?
Select or right-click the horizontal axis, choose Format Axis, and set the minimum, maximum, and major unit under Axis Options. The X-axis scale controls the displayed position of the horizontal values, not the source data.
Can I make an Excel scatter plot start at zero?
Yes. In Format Axis, set the minimum bound to 0 instead of Auto. Do this only if zero is appropriate for the data and the intended comparison; a zero baseline is not automatically the best choice for every measurement.
Why does my scatter plot have the wrong horizontal values?
The series may be using the wrong X-value range, or the chart may be a line chart rather than an XY scatter chart. Use Chart Design > Select Data, edit the series, and check its X and Y ranges.
Can I show dates on a scatter plot axis?
Yes, if Excel recognizes the X values as dates or date serial values. A scatter chart positions them according to their numeric date values, so gaps between dates affect spacing. Apply an appropriate date number format to the axis labels and check that the worksheet entries are real dates rather than text.
Why can’t I choose a logarithmic scale?
Logarithmic scales require positive plotted values. Check the series for zero or negative X or Y values on the axis you want to scale; if they are present, use a linear scale or another suitable charting approach.
Do axis settings change my worksheet data?
No. Bounds, units, number formats, and axis crossing settings alter the chart’s display. They do not rewrite the values in the source cells.
Related
- Excel Set Print Area: Steps, Tips, and Fixes
- MS Excel Solver: How It Works, Setup, and When to Use It
- Excel: Split a Cell by Hyphen in 4 Ways
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Undo an Excel Table Without Losing Your DataTo undo an Excel table while keeping its contents, select any cell in the table, choose Table Design…
- Windows 11 Excel Keyboard Shortcuts for Faster WorkIn Excel for Microsoft 365 on Windows 11, the most useful keyboard shortcuts include Ctrl+S to save, Ctrl+Z…
- Excel Number Format: How It Works and When to Use ItIn Excel, the Number format controls how a cell’s numeric value appears—for example, with two decimal places, a…
- Mail Merge in Word and Outlook: A Step-by-Step GuideTo mail merge in Word and Outlook, prepare a contact list in Excel, create an email in Word,…
- Find Common Names in Two Excel Sheets: A Quick GuideTo find names that appear in both sheets, put the names in column A of worksheets named List1…
- How to Change Date Format in Excel on Windows 11To change how dates appear in Excel on Windows 11, select the date cells, press Ctrl+1, choose a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.