Chart & Visualization Issues

Format and Adjust a Time Axis in an Excel Scatter Chart

Nimra MalikNimra Malik Nov 18, 2026 869 views

Question details

Set the bounds, interval, and label format for the horizontal time axis in a scatter chart.

Format and Adjust a Time Axis in an Excel Scatter Chart
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to control the time range and spacing on a scatter chart's horizontal axis.
Observed behavior
The horizontal axis should display the chosen time range at regular intervals with readable time labels.
Before you start

Confirm that the chart is an XY (Scatter) chart and that its X values are stored as actual time values, not text. Excel stores times as fractions of a 24-hour day.

Solution 1Recommended

Set the Time Axis Bounds and Units in Excel

Use Format Axis to specify the visible time range, interval, and label format.

Convert a time to an axis value by dividing its minutes after midnight by 1,440. Convert an interval in minutes the same way.

1
Open Format Axis

Right-click the chart's horizontal axis and select Format Axis.

2
Set the bounds

Under Axis Options, enter numeric values for Minimum and Maximum. For example, use 0.3333333333 for 8:00 AM and 0.5 for 12:00 PM. For a 1:55 AM start, enter approximately 0.0798611111.

3
Set the interval

Under Units, enter the Major interval as a fraction of a day. For 30 minutes, enter approximately 0.0208333333, calculated as 30 divided by 1,440.

4
Format the labels

In the Format Axis pane, open Number and choose a time format or enter a custom format such as hh:mm or hh:mm:ss.

Set the Time Axis Bounds and Units in Excel
Times that cross midnight: For a range that continues into the next day, the X values and maximum bound must include the next day's serial value, rather than using time-only values that reset to zero at midnight.
WPS Spreadsheets

Adjust a Scatter Chart Time Axis in WPS Spreadsheets

Open your workbook in WPS Spreadsheets and use the axis formatting controls to set the time range, major interval, and label format.

  1. 1. Open the workbook: Open your Excel workbook in WPS Spreadsheets and select the scatter chart.
  2. 2. Open axis formatting: Right-click the horizontal axis and select Format Axis.
  3. 3. Enter bounds and units: In Axis Options, set Minimum and Maximum to the desired time values as fractions of a day. Set the Major unit to the interval, such as 0.0208333333 for 30 minutes.
  4. 4. Format the time labels: Open the axis Number settings and select a time format or enter a custom format such as hh:mm.
Control the visible range and spacing of a scatter chart time axisOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet and chart formatting toolsWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel use decimals for time axis values?

Excel stores one day as 1, so a time is a fraction of a day. For example, 8:00 AM is 8 divided by 24, or approximately 0.3333333333.

How do I show 15-minute intervals on the axis?

Right-click the horizontal axis, select Format Axis, and set the Major unit to approximately 0.0104166667, which is 15 divided by 1,440.

How do I start the axis at 1:55 AM?

In Format Axis under Axis Options, set the Minimum bound to approximately 0.0798611111. This is 115 minutes divided by 1,440.

How can I display seconds in the axis labels?

Right-click the axis, select Format Axis, and open Number. Choose a time format with seconds or enter the custom format hh:mm:ss.

How do I plot times that pass midnight?

Include dates with the X values, or otherwise represent the next day's times with values greater than or equal to 1. Set the axis bounds to match those values so the times appear in chronological order.