Format and Adjust a Time Axis in an Excel Scatter Chart
Question details
Set the bounds, interval, and label format for the horizontal time axis in a 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.
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.
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.
Right-click the chart's horizontal axis and select Format Axis.
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.
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.
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.

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. Open the workbook: Open your Excel workbook in WPS Spreadsheets and select the scatter chart.
- 2. Open axis formatting: Right-click the horizontal axis and select Format Axis.
- 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. Format the time labels: Open the axis Number settings and select a time format or enter a custom format such as hh:mm.

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.




