Excel Bubble Chart Axis Settings: How to Set the Scales

Charts & pivot tables · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, select an axis in the bubble chart, right-click it, and choose Format Axis to set its minimum, maximum, units, and crossing point. The horizontal axis plots each point’s X value, the vertical axis plots its Y value, and the bubble size represents a separate third value.

What bubble chart axes control

A bubble chart is a type of XY (scatter) chart. Both axes use numerical values, so the position of a bubble is determined by its X and Y coordinates rather than by a category label. This makes the chart useful for comparing three numeric measures at once: position along the horizontal axis, position along the vertical axis, and bubble size.

Axis settings change how the data is displayed, not the values stored in the worksheet. For example, changing the horizontal axis minimum from 0 to 20 zooms in on the portion of the X scale from 20 onward. It does not recalculate or remove the underlying observations. However, points with coordinates outside the displayed bounds can disappear from view, so check the chart after changing a limit.

Excel normally chooses axis limits and tick spacing automatically. That is convenient for a first chart, but automatic scaling can make comparisons harder: two charts with the same data range may use different scales, or a single extreme value may compress the rest of the points. Setting bounds deliberately can make the plot easier to interpret.

Arrange the data before creating the chart

For a simple bubble chart, place the three measures in adjacent columns, with one observation per row. For example, a product comparison might use advertising spend for X, monthly sales for Y, and customer count for bubble size. Add a header above each column so Excel can use the headings when it labels the series.

  • Column A: advertising spend, used for the X values.
  • Column B: monthly sales, used for the Y values.
  • Column C: customer count, used for bubble size.

Select the data, then choose Insert > Insert Scatter (X, Y) or Bubble Chart and select a bubble chart. If Excel assigns the columns incorrectly, select the chart and use Chart Design > Select Data. In the Select Data Source dialog, select the series and choose Edit to check the series name, X values, Y values, and bubble size range. Each range should cover the same set of observations and should not include its header cell as a data point.

If your worksheet has several groups, each group can be a separate series. Keep each series’ X, Y, and size ranges aligned row by row. A common setup error is to select the right columns but mismatched rows; Excel still draws a chart, but the resulting positions and sizes no longer describe the intended records.

Open the axis settings in Excel

Click the horizontal or vertical axis on the chart, right-click, and choose Format Axis. You can also select the axis and use the Chart Format tab’s Format Selection command. Excel opens the Format Axis pane, where Axis Options contains the scale controls. Choose the horizontal axis when adjusting X values and the vertical axis when adjusting Y values.

  1. Click the axis labels or tick marks, not a bubble or a gridline.
  2. Right-click and choose Format Axis.
  3. In the pane, open Axis Options if it is not already expanded.
  4. Enter a value in Bounds > Minimum or Maximum to set a fixed endpoint, or use the automatic setting to let Excel choose it.
  5. Adjust Units > Major or Minor if you want different tick spacing, then close the pane and review the chart.

In Excel for Mac, select or Control-click the axis and choose Format Axis; the formatting pane provides similar axis options, though ribbon placement and some labels can differ. Excel for the web has chart-formatting controls, but the full set of desktop options may not be available in every interface. For detailed axis work, open the workbook in the desktop app.

Choose useful minimums, maximums, and units

Set bounds to match the question the chart should answer. If X values range from 18 to 74 and you want to compare their spread, a horizontal minimum of 0 may waste space; a fixed minimum near the data can make differences easier to see. But if the values represent quantities for which zero is meaningful, such as units sold, starting at zero may better communicate the scale. The best choice depends on the measure and the comparison—not on a rule that every axis must start at zero.

For a direct comparison between charts, use the same fixed bounds and major units on each chart. Otherwise, a point at the same location relative to the plotted area might represent different actual values in each chart. Conversely, if one chart contains a much wider range, forcing identical limits can crowd the observations together. Explain the chosen range clearly, especially when a nonzero baseline could affect how readers perceive differences.

Major units determine the spacing between labeled tick marks. If the axis runs from 0 to 100, a major unit of 20 gives labels at intervals of 20; a major unit of 10 provides more detail. Minor units add smaller intervals between major ticks, where supported by the chosen axis scale. Use a spacing that helps readers estimate values without filling the plot with so many lines that the bubbles become difficult to see.

Allow a little room around the data. Axis limits apply to bubble centers, but the circles extend beyond those coordinates. A bubble whose center is just inside the maximum can be partly cut off at the edge of the plot area. Increase the upper bound or lower the minimum slightly if the largest circles appear clipped.

Set axis crossings, number formats, and gridlines

Axis crossing controls where one axis meets the other. In the Format Axis pane, the vertical axis includes a setting for where the horizontal axis crosses, and the horizontal axis includes the corresponding setting for the vertical axis. Depending on the selected axis and chart, the available choices can include automatic crossing, crossing at an axis value, or crossing at the maximum. Use a specific crossing value when the intersection should represent a meaningful reference, such as zero.

Changing a crossing point is not the same as changing a bound. Bounds control the visible range; crossing controls the location of the perpendicular axis within that range. For instance, if a vertical axis includes negative and positive values, the horizontal axis can cross at zero rather than staying at the bottom edge. If zero is outside the displayed range, Excel may place the crossing at an edge or offer a maximum-crossing choice instead.

Use the Number section in Format Axis to choose how tick labels appear, such as currency, percentage, or a chosen number of decimal places. Formatting changes the labels, not the data or scale. Check that the format matches the units: showing a value of 0.25 as 25% is appropriate only if the underlying measure is a proportion.

Gridlines are chart elements rather than axis bounds. To add or remove them, select the chart and use Chart Design > Add Chart Element > Gridlines, then choose the direction and type you need. Light major gridlines can help readers estimate coordinates; too many prominent gridlines compete with the bubbles. Axis titles, available through Chart Design > Add Chart Element > Axis Titles, can state the measure and unit, such as “Monthly sales (thousands of dollars).”

Understand bubble size separately from axis scale

Bubble size is not a third axis. It is encoded by the area of each circle, so readers compare a size value by comparing the circle’s visual area rather than its horizontal or vertical position. Excel’s Format Data Series options include a bubble-size scale adjustment; it changes the display size of the bubbles in the series, not the X or Y bounds. If all circles are too small or obscure one another, adjust that setting carefully and recheck the result.

Choose a size measure with a clear interpretation and sensible positive values. A bubble chart can become misleading if the largest circle overwhelms nearby points or if several circles overlap. Consider using a size measure with a smaller range, making the overall bubbles smaller, or labeling only important points. Do not assume that a bubble twice as wide represents twice the size value: because area grows in both dimensions, diameter and the underlying size value are not the same thing.

Excel also offers a three-dimensional bubble chart option, but perspective can make positions and sizes harder to judge. For most comparisons, a standard two-dimensional bubble chart is easier to read and keeps the horizontal and vertical scales interpretable. Use the 3-D version only when its visual effect serves a clear purpose and does not obscure the data.

Fix common axis and bubble chart problems

  • The chart has the wrong axes: Open Chart Design > Select Data and edit the series ranges. Confirm that the intended X, Y, and size columns are assigned to the right fields.
  • The points are compressed at one edge: Check for an unusually large or small value, then review the automatic bounds. Set a suitable fixed range only if it preserves the comparison you need.
  • Bubbles are cut off: Add padding to the axis bounds, remembering that a bubble’s edge extends beyond its center coordinate.
  • Labels or gridlines are crowded: Increase the major unit, remove minor gridlines, or use fewer decimal places. Keep enough reference marks to estimate values.
  • The chart looks different after filtering or editing data: Recheck automatic bounds and series ranges. Excel may adjust the displayed scale when the plotted values change.
  • A logarithmic scale is unavailable or fails: Logarithmic axes require positive values; zero and negative coordinates cannot be represented on that scale. Use a linear scale if the data includes zero or negative values.

When investigating an unexpected chart, check data selection before adjusting the visual design. A wrong size range or an accidental header in the series can make a correct axis appear wrong. Also verify whether a point is genuinely outside the chosen bounds rather than hidden behind a larger bubble.

When a bubble chart is the right choice

Use a bubble chart when each observation has three meaningful numeric measures and the extra size encoding adds useful context. For example, a regional chart could show population on X, growth rate on Y, and total revenue as bubble size. If the third measure is not important, a regular scatter chart is usually clearer. If the horizontal positions are categories rather than numeric measurements, a column or bar chart may communicate the comparison more naturally.

Bubble charts are less effective when many points overlap, when readers need exact comparisons of the third measure, or when the size values differ only slightly. Consider a scatter chart with color or labels, a table, or small multiple charts in those cases. Whatever chart type you choose, label both axes with units and explain what bubble size means; otherwise, readers may correctly see the pattern but misread the measures.

Frequently Asked Questions

How do I change the X-axis scale in an Excel bubble chart?
Select the horizontal axis, right-click, choose Format Axis, and set Bounds > Minimum or Maximum in Axis Options. The X-axis displays the series’ X values.

How do I change the Y-axis scale?
Select the vertical axis and open Format Axis. Set its minimum, maximum, and major unit under Axis Options. These settings affect the displayed range and tick spacing, not the worksheet values.

Can I make a bubble chart axis start at zero?
Yes. In Format Axis, set the relevant Minimum bound to 0. Do this when zero is meaningful for the comparison; otherwise, a nonzero minimum may show the variation more clearly, provided the scale is not misleading.

Why are some bubbles missing or cut off?
A bubble may be outside the axis bounds, hidden behind another bubble, or associated with an incorrect series range. Widen the bounds to check for clipping and inspect the X, Y, and size assignments in Select Data.

Can Excel use a logarithmic scale on a bubble chart?
Excel can offer a logarithmic scale for an axis when its values meet the requirements, but logarithmic scales cannot represent zero or negative coordinates. If those values matter, keep the axis linear.

Does changing the bubble-size setting change the axis?
No. The series’ bubble-size adjustment changes how large the circles appear. Horizontal and vertical axis settings still control the plotted X and Y coordinate ranges.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

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

Spotted an error in this guide? Let us know.