How to Add Filterable Categories to an Excel Milestone Timeline
Question details
The user needs to organize and display more than 100 milestones in an Excel Milestone Timeline template by adding filterable categories.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Managing a large project timeline with multiple milestone categories, requiring the ability to view specific categories, combinations of categories, or all milestones together.
- Observed behavior
- The default timeline template displays all milestones at once without an option to filter them by category, which causes visual clutter when dealing with over 100 entries.
Ensure you have your Excel Milestone Timeline template open and check that your worksheet is unprotected so you can modify hidden columns and chart settings.
Add a Category Column and Configure Chart Filters
Modify the underlying timeline data by unhiding columns, adding a category field, and configuring the timeline chart to hide filtered out categories dynamically.
To make your timeline dynamic, you need to add a dedicated Category column to the source data and instruct the timeline chart to ignore data hidden by the filter.
Highlight columns E through H (or the columns adjacent to your visible data), right-click on the column headers, and select 'Unhide' to reveal the chart's hidden calculation data.
Click on cell I4 (or the next available column header row) and type 'Category'. Fill in the appropriate category name for each milestone down the column.
Select your entire data table including the new Category column. Go to the 'Data' tab on the ribbon and click 'Filter' to add drop-down filter arrows to your headers.
Right-click the timeline chart and select 'Select Data'. Click the 'Hidden and Empty Cells' button at the bottom left of the dialog box, and ensure 'Show data in hidden rows and columns' is unchecked.
Right-click a milestone data label on the chart and choose 'Format Data Labels'. Check the 'Value From Cells' box, then select the data range of your new Category column to display the category names on the timeline.

Manage Filterable Timelines Easily with WPS Spreadsheet
WPS Spreadsheet provides powerful filtering and charting capabilities, making it seamless to manage complex milestone timelines with hundreds of categorized events.
- 1. Open your template: Launch WPS Spreadsheet and open your existing Excel Milestone Timeline template.
- 2. Unhide and add categories: Select the columns next to your data, right-click, select 'Unhide', and add a new 'Category' column with your specific milestone groupings.
- 3. Apply filters and map labels: Use the Filter tool from the Data tab to enable dropdowns, then format your chart's data labels by choosing 'Value From Cells' and mapping them to your new Category column.

Frequently Asked Questions
Why are my filtered milestones still showing on the timeline chart?
By default, charts may display data from hidden rows. To fix this, right-click your chart, click 'Select Data', navigate to 'Hidden and Empty Cells', and ensure 'Show data in hidden rows and columns' is unchecked.
Can I filter multiple categories at the same time?
Yes. Once you enable the filter drop-down on your Category column, you can check the boxes for multiple categories to display combinations of milestones on the timeline simultaneously.
How do I format the category labels on the chart?
Right-click the data labels directly on the chart, select 'Format Data Labels', and use the settings panel on the right side of the screen to change the font, color, and alignment of the text pulled from your category cells.




