How to Plot Time-Stamped Data on an XY Scatter Chart in WPS Office Spreadsheets
Question details
The user needs to plot timestamped data with irregular intervals on an XY chart so each point appears at its actual timestamp rather than at evenly spaced row positions.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user has time-stamped records, such as sensor logs or event data, with irregular time intervals and wants to visualize them accurately.
- Observed behavior
- The chart plots points by row order or fails to use actual timestamps when the timestamp range includes comments or text entries.
Before creating the chart, confirm that the timestamp column contains only valid date/time values and no comments or text entries in the selected X-axis range. Select only the numeric time column and the data series you want to plot.
Plot irregularly timestamped data as an XY Scatter chart in WPS Office Spreadsheets
Use this when you need points placed according to real numeric time values, not by row order.
An XY Scatter chart treats both X and Y values as numbers. Time values must therefore be stored as Excel/WPS date-time serial numbers or time values, not as text labels.
If comments or text notes are inside the timestamp column, they can make the entire X range nonnumeric and prevent correct plotting.
Open your workbook in WPS Office Spreadsheets and check the timestamp column. Remove or move any comments, notes, or text entries to a separate column so only valid date/time values remain in the X-axis range.
Select the timestamp column and the corresponding data series. Hold Ctrl if you need to select non-adjacent columns.
Go to the Insert tab and click Chart. In the chart type dialog, choose XY (Scatter), then pick a scatter subtype such as Scatter with Straight Lines and Markers or Scatter with Only Markers.
Right-click the chart and choose Select Data. In the Select Data Source dialog, confirm the X-axis values point to the cleaned timestamp cells. Click OK.
Right-click the X-axis and choose Format Axis. Set the correct number format to time or date/time so labels display properly.
Move comments or text entries out of the timestamp range
Use this if your existing XY scatter chart stops plotting correctly because comments or text were entered between timestamps.
Create a Time-Aware XY Scatter Chart in WPS Office Spreadsheets
WPS Office Spreadsheets can plot irregularly timed data at its actual timestamps using the built-in XY Scatter chart. Prepare a numeric time column, insert a scatter chart, and point the X-axis at the timestamp cells for accurate visualization.
- 1. Open or import your timestamped workbook: Launch WPS Office Spreadsheets and open your .xlsx or .xls file containing the timestamped data.
- 2. Clean the timestamp column: Ensure the X-axis column contains only valid date/time or numeric time values. Move comments or text notes to a separate column.
- 3. Insert an XY Scatter chart: Select the cleaned data, go to the Insert tab, click Chart, and choose XY (Scatter). Pick the scatter subtype that fits your data.
- 4. Assign timestamp cells to the X-axis: Right-click the chart, choose Select Data, and confirm the X-axis values point to the numeric time column instead of text or comment cells.
- 5. Format and review the chart: Open Format Axis to set the desired time or date number format, then check that points appear at the expected timestamps.
Frequently Asked Questions
Why does my XY scatter chart ignore the actual timestamps?
Because the X-axis range likely contains text, comments, or invalid date/time values. In WPS Office Spreadsheets, an XY scatter chart requires numeric values on the X-axis. Move comments or text notes to a separate column, then reselect the cleaned timestamp range via Chart > Select Data.
How do I insert an XY Scatter chart in WPS Office Spreadsheets?
Select your numeric timestamp and data columns, click the Insert tab, then click Chart. In the chart type list, choose XY (Scatter) and select a scatter subtype.
Can I use time values like 10:15:30 as the X-axis in a scatter chart?
Yes, as long as they are stored as WPS/Excel date-time values rather than text. Select the cells and check the Number Format on the Home tab; use a Time or Custom date-time format if needed.
What should I do if comments were entered between timestamps and the chart stopped working?
Insert a separate Notes column next to the timestamp column. Cut the comments from the timestamp cells, paste them into Notes, then right-click the chart and choose Select Data to set the X-axis to only the cleaned timestamp column.
Does WPS Office support Excel XY scatter chart files?
Yes, WPS Office Spreadsheets opens and saves Excel .xlsx and .xls files, including XY scatter charts and date/time formatting, without requiring Microsoft Office.
