It is mainly used for date filtering in your underlying datasets which contains date field in a pivot table. Depending on your version of Excel, either click the SmartArt tab in the ribbon menu, or click the Insert tab, then the SmartArt button. Pressing tab will enter a description of the current section. When you press enter, you will start a new line/section of the timeline. To create a pivot table, below mentioned steps are followed: Here, I need to base a PivotChart on created pivot tables in that sheet, therefore copy that sheet “PivotChart_Timeline” or create another copy, with a “PivotChart_Timeline” as sheet name. If you're not satisfied with these options, try PowerPoint, which has more graphics options. Click anywhere in the Pivot table and go to Insert tab. By using this service, some information may be shared with YouTube. Note: if the text pane is not visible, you can click the small arrow to the left of the chart to expand or collapse it. In the time level option, you can select four different time levels based on your choice. In the dashboard, you have the option to combine the timeline with Slicer. Once you have click on the Insert Timeline button, the Insert Timeline pop-up window appears. Here we discuss how to use timeline tools in excel to create a Timeline in Excel along with practical examples and a downloadable excel template. Your timeline … (You can name the sheet as “PIVOTTABLE_TIMELINE” ). Click on OK. For your Timeline, you can configure or select group dates by years, quarters, months, or days with the help of the drop-down list.  ​  Refer below screenshot. Suppose I want the Timeline filtering a PivotTable to show only results from the year 2018. All tip submissions are carefully reviewed before being published. Timelines are a special form of excel for PivotTables to filter dates. This button can be used to clear all Timeline options in excel (It may be either days or months or quarters or years). Here I have selected a year in the below-mentioned e.g.Years. This option was first introduced in Excel 2013 Version. helpdesk@nmu.edu Your timeline will appear on the spreadsheet. Drag the right or left side of the box outward. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e0\/Create-a-Timeline-in-Excel-Step-1-Version-4.jpg\/v4-460px-Create-a-Timeline-in-Excel-Step-1-Version-4.jpg","bigUrl":"\/images\/thumb\/e\/e0\/Create-a-Timeline-in-Excel-Step-1-Version-4.jpg\/aid3771388-v4-728px-Create-a-Timeline-in-Excel-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"