128k views
4 votes
Add a timeline slicer to the PivotTable based on the Date field in the SpringWorkshops table.

1 Answer

6 votes

To Add a timeline slicer to the PivotTable based on the Date field in the SpringWorkshops table, the steps are:

Step 1: Select Cell B6: Click on cell B6 to ensure the PivotTable is selected. This will make sure that the timeline slicer is associated with the PivotTable.

Step 2: Access the "Analyze" Tab: Navigate to the "Analyze" tab in the ribbon. This tab contains various tools for analyzing data, including pivot tables, charts, and slicers.

Step 3: Click "Insert Timeline": In the "Filter" group of the "Analyze" tab, locate the "Insert Timeline" button. Click on this button to initiate the insertion of a timeline slicer.

Step 4: Select "Date": In the "Insert Timelines" dialog box, you'll see a list of available fields for creating a timeline slicer. Select the "Date" field from the list. This will ensure that the timeline slicer filters the PivotTable based on dates.

Step 5: Click "OK": Once you've selected the "Date" field, click the "OK" button to insert the timeline slicer into the worksheet. The timeline slicer will appear below the PivotTable, allowing you to filter the data based on specific date ranges.

See text below

36. Add a timeline slicer to the PivotTable based on the Date field in the SpringWorkshops table

a.Click cell B6

b.Click on the “analyze” tab in the ribbon

c.Click “Filter” d.Click “insert timeline”

e.Click “date” f.Click “OK

User Richard Robinson
by
8.5k points