How to Create One Excel Timeline for Multiple Date Columns in WPS Spreadsheets
Question details
The user wants to create one Excel/WPS PivotTable timeline that filters multiple date columns independently and returns separate counts for each original date column.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is building a PivotTable report from a source table that contains several date columns and wants a single timeline to filter all of them at once.
- Observed behavior
- A standard PivotTable timeline filters only one date field and applies conditions together; it cannot combine several date columns with an OR condition for separate counts.
Open the workbook in WPS Spreadsheets and identify the multiple date columns to be filtered. Decide on a common event or category name for each source date column so the normalized table can keep the original counts separate.
Normalize multiple date columns into one Date column and one Event column
Use this when you need a single timeline to filter all dates and still show separate counts for each original date column.
A PivotTable timeline can filter only one date field. When the source data contains multiple date columns, stack those dates into one Date column and add an Event column that identifies the original column name. This creates a normalized PivotTable source that supports one timeline and separate counts.
Launch WPS Office, open the .xlsx workbook, and select the worksheet that contains the multiple date columns.
Click the plus icon next to the sheet tab to insert a new sheet. Enter headers such as Event, Date, and Value. In the Event column, type the original date column name; in the Date column, stack the corresponding date values below each other.
Select the normalized data range, go to Insert > PivotTable, choose New Worksheet, and click OK.
In the PivotTable Fields pane, drag Event to Rows, Date to Rows or Columns, and Value to Values. Make sure the Date field is recognized as a date format.
Select any cell in the PivotTable, go to PivotTable Tools > Analyze > Insert Timeline, choose the Date field, and click OK. If the Timeline command is not available, use Insert Slicer and select the Date field.
Use WPS Spreadsheets to Build a Single Date Field and One PivotTable Timeline
WPS Spreadsheets can complete this task by normalizing multiple date columns into one Date field and one Event field, then inserting a single PivotTable timeline that filters all dates while keeping the original columns as separate count groups.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office and open the .xlsx file that contains the multiple date columns.
- 2. Build a normalized date table: Create a new sheet and stack all date values into one Date column, adding an Event column that records the original date column name.
- 3. Create a PivotTable: Select the normalized table, click Insert > PivotTable, and choose New Worksheet.
- 4. Insert a timeline for the Date field: Select the PivotTable, go to PivotTable Tools > Analyze > Insert Timeline, choose Date, and click OK.
- 5. Test the OR-style filter: Drag Event to Rows and the value field to Values, then use the timeline to filter all stacked dates and view separate counts.
Frequently Asked Questions
Can an Excel PivotTable timeline filter two date columns at the same time?
No. A single PivotTable timeline filters only one date field. To filter multiple date columns together, stack the dates into one Date column and add an Event column that identifies the original column name.
Does WPS Spreadsheets support PivotTable timelines?
WPS Spreadsheets supports date filtering in PivotTables. After adding a recognized Date field to the PivotTable, use PivotTable Tools > Analyze > Insert Timeline. If the Timeline command is not listed, use Insert Slicer and select the Date field.
How do I keep separate counts for each original date column after normalizing?
Add the original column name as an Event column in the normalized table. In the PivotTable, place Event in the Rows area and the value field in the Values area so each original column is counted separately.
Why does my timeline apply conditions together instead of using OR logic?
Timeline filtering works on a single date field, so it applies to the whole PivotTable. Independent date columns are not combined with OR logic unless the source data is normalized into one Date field with an Event or Category field.
Can I prepare the normalized table with formulas in WPS Spreadsheets?
Yes. You can use formulas or manual stacking to create the normalized Date and Event columns. Then point a PivotTable to the new range and insert the timeline or date slicer.
