Cannot find Bounds and Units under Format Axis

Question

Excel bar graph - In formatting the X axis for dates: I select Format Axis, Axis Options, Axis Type and Date Axis. I then should get Bounds and Units feature but this does not appear. My data source field is Date and then *3/14/2012. I believe this is correct, but I still do not get Bounds and Units. I have checked various recommended solutions on the web but have yet to find one that works.

Any suggestions?

Thank you

Answer 1

Hi William Bielfeldt

What you’re seeing is usually related to the chart type and the kind of axis Excel is using, rather than an issue with the date values themselves.

In Excel terminology:

• A Bar chart is horizontal
• A Column chart is vertical

In a horizontal Bar chart, dates are typically placed on the vertical (Y) axis, and Excel normally treats that axis as a Category axis. When an axis is treated as a Category axis, the Bounds and Units options do not appear, which is expected behavior.

If you want the dates along the bottom with Bounds available, you’ll typically see that with a Column chart or an XY (Scatter) chart, where the date axis is treated as a value‑based axis.

Also, even when a Date axis is working correctly in a Column chart, Excel may show the axis limits as large numbers or decimals. Excel stores dates internally as serial numbers (number of days since 1/1/1900).

A few things you can double‑check:

• Confirm the dates are real dates, not text Try =ISNUMBER(A2) If it returns TRUE, Excel recognizes the value as a date.
• Check the chart type If it’s a Bar chart, missing Bounds is usually expected. If it’s a Column chart and Date Axis is selected, the Bounds fields should normally appear.
• Refresh the Format Axis pane (this can help in some Microsoft 365 builds):
  • Click Reset in the Format Axis pane
  • Change the Major unit once, then check again
  • Click away from the chart and re‑select the axis
  • Recreate or refresh the chart if needed

In most cases, this behavior comes down to Excel treating the selected axis as a Category axis, or the Format Axis pane not refreshing immediately and not a problem with the date values themselves.

If you’d like, feel free to share the chart type you’re using or what axis the dates are currently on, and we can take a closer look.

Please let me know if this proves useful to you, or if you would like further assistance.

I'm looking forward to your reply.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Bounds and Units on the horizontal axis are only available when the axis is treated as a value (date) axis with scalable units. In Excel, the options that appear depend on the chart type and on how the axis is defined.

For date-based category axes, the key settings are under Axis Type and Units:

1. Right-click the horizontal (category) axis and select Format Axis.
2. In the Format Axis pane, on Axis Options:
   • Under Axis Type, choose Date axis (not Text axis).
   • Under Units, next to Base, choose Days, Months, or Years.

If the axis is actually a text/category axis, or if the chart type does not support date axes in the way expected, the Bounds and Units controls for scaling will not appear. In that case, Excel either:

• Treats the dates as text and spaces them evenly (Text axis), or
• Automatically selects the axis type based on the data and chart type (the Automatically select based on data option).

To adjust scaling when Bounds/Units are not shown, use the available date-axis controls:

1. Ensure Axis Type is set to Date axis.
2. Use Base under Units to control whether the axis steps by days, months, or years.
3. If Excel is filling in missing dates and that behavior is not desired, switch the axis to Text axis instead of Date axis so dates are treated as discrete categories rather than a continuous time scale.

If Bounds and Units still do not appear after confirming the axis is a Date axis, the chart type or Excel version may not expose those specific controls for the horizontal axis; in that case, only the Base unit and tick-mark interval can be adjusted.

---

References:

• Display or change dates on a category axis
• Change the scale of the horizontal (category) axis in a chart
• Dates are made consecutive when you create charts in Microsoft Excel
• Create a chart from start to finish