Chart & Visualization Issues

WPS Spreadsheet: Show Hours and Minutes on a Chart Axis

Phi Hung VoPhi Hung Vo Nov 12, 2026 869 views

Question details

The user needs to display individual hours and minutes instead of broader day, month, or year groupings on a chart axis.

WPS Spreadsheet: Show Hours and Minutes 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.
Before you start

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.

Solution 1Recommended

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.

1
Select the chart

Click the existing chart in WPS Spreadsheet to display the chart editing tools.

2
Change the chart type

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.

3
Open horizontal-axis formatting

Right-click the horizontal axis and choose Format Axis to open the axis settings panel.

4
Set the time number format

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.

5
Set the major interval

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.

Check the source values: If the axis still does not show the expected times, select a source cell and inspect its number format. Text such as “09:30” must be converted to a real time value before the chart can position it correctly.
WPS Office solution

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. 1. Insert or select a chart: Open your worksheet in WPS Spreadsheet, select the date-time and measurement data, and use Insert > Chart.
  2. 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. 3. Format the time axis: Right-click the horizontal axis, select Format Axis, open Number, and apply the custom format hh:mm.
  4. 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.
Precisely display hours and minutes on chart axes with custom time formattingUse numeric date-time values to control chart spacing and intervalsCreate and edit XY scatter charts in a familiar spreadsheet interfaceOpen and save Microsoft Excel XLS and XLSX chart files with broad format compatibility
microsoft office alternative - wps office

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.