Pivot table timelines allow you to quickly shift your pivot table according to dates and time, as well as zoom in and out of specific time periods. Fortunately, adding a timeline to your pivot table is no more difficult than a few clicks of the mouse.

Show Total Time in Pivot Table

1. In the pivot table, right-click a cell in the time field, and click Value Field Settings.
2. In the Value Field Settings dialog box, click Number Format.
3. In the Category list, click Custom.
4. In the Type box, enter: [h]:mm (That format totals the hours)
5. Click OK, twice, to close the dialog boxes.

Creating a Timeline in Excel

1. In the “Insert” tab on the ribbon, select “Smart Art” from the “Illustrations” section.
2. In the left pane of the new window, select the “Process” option, then double-click one of the timeline options, or select an option and select “OK.”
3. Your timeline will appear on the spreadsheet.

Click anywhere in a PivotTable to show the PivotTable Tools ribbon group, then click Analyze > Insert Timeline. In the Insert Timeline dialog box, check the date fields you want, and click OK.

A timeline in excel is a kind of SmartArt that displays the different timings of a particular process. The timeline was first introduced in Excel 2013. The pivot table and the pivot chart help summarize and analyze data.

You can name that sheet as “Insert_Timeline”. To create a Timeline in excel, you can click anywhere on a dataset in your PivotTable and then select the Analyze tab on the Ribbon. Click on Insert Timeline button in the Filter group.

Building the Pivot Table Load the spreadsheet you want to create the Pivot Table from. Ensure that your data meets the needs of a pivot table. Start the Pivot Table wizard. Select the data you want to use. Select the location for your Pivot Table.

1. Click any cell in your pivot table, and the PivotTable Tools tab will be displayed. 2. Under the PivotTable Tools tab, click Design > Report Layout > Show in Tabular Form, see screenshot: 3. And now, the row labels in the pivot table have been placed side by side at once, see screenshot:

Follow this process: Specifying the data range If your data is in a worksheet range, just select any cell in the range. We select cell A2 in our “data” worksheet. Creating a blank pivot table Click OK to choose the options as it is. Excel creates an empty pivot table and displays a PivotTable Fields task pane. Laying out the pivot table