WPS Spreadsheet: Show Hours and Minutes on a Chart Axis
Question details
The user needs to display individual hours and minutes instead of broader day, month, or year groupings on a chart axis.

- Product
- WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- A line chart uses date-time values, but the horizontal axis must show time intervals such as one hour.
- Observed behavior
- The chart groups date and time values into larger calendar units, preventing individual hours and minutes from appearing clearly.
Check that the source time values are real spreadsheet date-time serial numbers rather than text strings. Decide the interval you want to show, such as one hour or 30 minutes, before formatting the axis.
Use an XY scatter chart and format the horizontal axis as time
Use this method when a line chart groups time values into days, months, or years and you need precise hour-and-minute intervals.
Spreadsheet date-time values are stored as fractions of a day. A one-hour interval is 1/24, while a 30-minute interval is 1/48. An XY scatter chart treats the time values as numeric positions, allowing the axis to use these precise intervals.
Click the existing chart in WPS Spreadsheet to display the chart editing tools.
Open the chart type menu from the chart tools or right-click the chart, choose Change Chart Type, and select XY (Scatter). Choose a scatter style that connects the points if you want a line chart appearance.
Right-click the horizontal axis and choose Format Axis to open the axis settings panel.
In the Format Axis panel, open the Number section, enter hh:mm in the format code or custom format field, and select Add or Apply.
In Axis Options, set the Major unit to 1/24 for one-hour spacing. Use 1/48 for 30-minute spacing or another fraction of a day for a different interval.
Convert text times into valid spreadsheet time values
Use this method when formatting the axis does not work because the source hours and minutes are stored as text.
Create Precise Hour-and-Minute Chart Axes in WPS Spreadsheet
WPS Spreadsheet lets you convert a time-based line chart to an XY scatter chart, apply an hh:mm axis format, and control the major interval so individual hours and minutes are easy to read.
- 1. Insert or select a chart: Open your worksheet in WPS Spreadsheet, select the date-time and measurement data, and use Insert > Chart.
- 2. Choose an XY scatter chart: Select the chart, open the chart type controls, choose XY (Scatter), and apply a connected-points style if required.
- 3. Format the time axis: Right-click the horizontal axis, select Format Axis, open Number, and apply the custom format hh:mm.
- 4. Set the interval: In Axis Options, enter 1/24 as the Major unit for one-hour labels, or use another fraction of a day for a different interval.

Frequently Asked Questions
Why does my chart show dates instead of individual hours?
A standard line chart may use a date axis that groups values into days, months, or years. Change the chart to XY (Scatter), then format the horizontal axis with hh:mm and set a suitable Major unit.
What value represents one hour on a spreadsheet chart axis?
Spreadsheet date-time values use one day as 1, so one hour is 1/24, or approximately 0.0416667. Enter 1/24 as the Major unit in the horizontal-axis settings.
How can I tell whether my time values are text?
Select a source cell and check whether it behaves as a numeric value when you change its format. If it remains text, use a helper formula such as =TIMEVALUE(A2), then use the converted results as the chart's X values.
Can I display minutes instead of hours on the axis?
Yes. Apply a format such as hh:mm and set a smaller Major unit. For example, 1/48 produces 30-minute intervals, while 1/1440 represents one minute.




