How to Fix Excel Line Charts Grouping Time-Series Data by Day in WPS Spreadsheets
Question details
The user needs to understand why a line chart in an Excel-compatible spreadsheet groups multiple date/time values from the same day and how to create a time-series chart that preserves actual time intervals.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is plotting date/time data in a line chart and wants an accurate time-series view instead of daily grouping.
- Observed behavior
- Excel line charts group multiple same-day timestamps into one category, producing a compressed or misleading chart.
Open the workbook in WPS Spreadsheets and verify that the date/time column contains real date/time values, not text. Select the full data range you want to chart before inserting an XY scatter chart.
Use an XY Scatter Chart with Straight Lines in WPS Spreadsheets
Use this when the horizontal axis contains actual date and time values and you need the chart to preserve proportional time intervals.
A line chart treats the horizontal axis as evenly spaced categories, which is why multiple values from the same day collapse into one point. An XY scatter chart treats the x-axis as numeric and shows the true spacing between timestamps.
Open your workbook in WPS Spreadsheets and select the two columns that contain the date/time values and the series values.
Go to the Insert tab, click the Scatter chart dropdown, and choose Scatter with Straight Lines and Markers.
Right-click the horizontal axis, choose Format Axis, and set Axis Type to Date axis or leave it as Automatic to preserve the numeric date/time scale.
Use the Chart Tools or Object Formatting pane to refine line style, markers, and labels so the time-series reads clearly.
Use a Line Chart for Evenly Spaced Nonnumeric Categories
Use this only when horizontal values are labels or evenly spaced categories, not continuous date/time measurements.
Create Accurate Time-Series Charts in WPS Spreadsheets
Switch from a category-based line chart to an XY scatter chart in WPS Spreadsheets to preserve actual date/time intervals. WPS Spreadsheets opens Excel workbooks, keeps formatting, and provides the same familiar chart tools for free.
- 1. Open your Excel file in WPS Spreadsheets: Launch WPS Spreadsheets, click Menu > Open, and select the Excel workbook that contains the time-series data.
- 2. Create the scatter chart: Select the date/time and value columns, go to the Insert tab, and choose Scatter with Straight Lines and Markers.
- 3. Format the time axis: Right-click the horizontal axis, choose Format Axis, and confirm the axis uses a date/numeric scale instead of text categories.
- 4. Save the workbook: Click Menu > Save As and choose Excel Workbook (*.xlsx) to keep the file compatible with Microsoft Excel.
Frequently Asked Questions
Why does my Excel line chart group all times from the same day into one point?
A line chart treats the horizontal axis as evenly spaced categories, not as numeric values. When your x-values are date/time values, multiple timestamps from the same day become one category. Use an XY scatter chart to plot them as numeric time intervals.
Which chart type should I use for continuous date and time data in WPS Spreadsheets?
Use an XY scatter chart with straight lines. Insert it from Insert > Scatter > Scatter with Straight Lines and Markers so the horizontal axis preserves actual date/time spacing.
Will changing from a line chart to a scatter chart affect my data?
No. The chart change only affects visualization. The underlying date/time and series values remain unchanged in the worksheet.
Can WPS Spreadsheets open and save Excel time-series charts?
Yes. WPS Spreadsheets opens .xlsx workbooks and can save the file as an Excel Workbook, keeping your chart and data compatible with Microsoft Excel.
How do I know if my horizontal axis values are being treated as categories?
In a line chart, horizontal labels often show evenly spaced categories. In an XY scatter chart, the axis scale shows date/time intervals and points are positioned proportionally.
