7. PivotTables and PivotCharts
7.8 Slicers and Timelines
In short: Slicers are clickable filter buttons; Timelines are date sliders (Excel 2013+).
Slicers are clickable filter buttons; Timelines are date sliders (Excel 2013+).
Steps in Excel
- Click the PivotTable › PivotTable Analyze › Filter › Insert Slicer › tick City and Platform › OK.
- Click a button to filter; Ctrl + click for several; the Multi-Select icon (or Alt + S) for touch-style selection; the Clear Filter icon (or Alt + C) to reset.
- Slicer tab › Buttons › Columns
3to lay buttons out horizontally; choose a Slicer Style. - PivotTable Analyze › Filter › Insert Timeline › tick Order Date › OK. Switch the level (Years / Quarters / Months / Days) in the top-right of the timeline and drag to select a period.
- Slicer Settings (right-click) › Hide items with no data.
Worked example. A small ops dashboard for Rani: slicers for City and Platform, a timeline on Order Date set to Months. She clicks Nagpur and drags the timeline over Nov 2026 – the pivot shows Nagpur's Diwali-month sales only.
Ravindra Bagale's Tip
If an item stays clicked in a slicer, the next person asks "why are sales so low?" – many students forget to clear the filter. Before saving the dashboard, clear all slicers or show the selected item in the heading. For a Timeline, the date column must contain real dates, not text.
Ravindra Bagale's Tip – मराठी
Slicer मध्ये एखाद्या item वर click केलेला राहिला तर पुढचा माणूस "sales कमी का?" म्हणतो – बरेच students clear filter विसरतात. Dashboard save करण्याआधी सगळे slicers clear करा किंवा selected item heading मध्ये दाखवा. Timeline साठी date column खरी date असायला हवी, text नाही.
Ravindra Bagale's Tip – हिंदी
Slicer में कोई item clicked रह गया तो अगला व्यक्ति पूछता है "sales कम क्यों?" – बहुत से students clear filter करना भूल जाते हैं. Dashboard save करने से पहले सारे slicers clear करो या selected item को heading में दिखाओ. Timeline के लिए date column में असली dates होनी चाहिए, text नहीं.
Worked example — slicers and timelines
Why
Priya Deshmukh in Pune and Sophie Martin abroad both need a clear, repeatable way to use slicers and timelines on a Maple Bakery Co sheet without breaking totals.
What
Slicers And Timelines is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for slicers and timelines.
- Enter a small made-up value for Priya Deshmukh using $ where money appears.
- Add a second value for Sophie Martin using ₹ so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once slicers and timelines is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of slicers and timelines on a blank sheet for FreshGo Mart.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Aarti Kulkarni and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Oliver Bennett.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply slicers and timelines to a 5-row made-up FreshGo Mart table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with slicers and timelines.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as FreshGoMart_practice.xlsx.
Hint: Use a clear file name for class.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
