To create a timeline slicer follow these steps.

Create timeline using excel.

The easiest way to make a timeline in excel is to use a pre made template. Click on the insert timeline button in the filter group. Excel will use these plotting points to vary the height of each milestone when plotting them on your timeline template. A microsoft excel template is especially useful if you don t have a lot of experience making a project timeline. To create a timeline chart in excel you need the following three columns of data. Place the cursor anywhere inside the pivot table and then click the analyze tab on the ribbon.

To create a timeline in excel you will also need to add another column to your table that includes some plotting numbers. In excel 2007 and 2010 click the timeline chart to activate the chart tools and then click the design save as template. Depending on your version of excel either click the smartart tab in the ribbon menu or click the insert tab then the smartart button. 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. 1 unit of time this column will contain units of time. Click process in the smartart ribbon.

When you want to show a sequence of events such as project milestones or events you can use a smartart graphic timeline. Add the new column next to your milestone description column and list out a repetitive sequence of numbers such as 1 2 3 4 or 5 10 15 20 ect. In excel 2013 right click the timeline chart and select the save as template from the right clicking menu. Click the tab s insert timeline command shown here. This option is available in excel 2007 or later step 3 select the timeline from the process submenu. Inserting a timeline slicer.

Step 1 create a new spreadsheet. After you create the timeline you can add events move events change layouts and colors and apply different styles. See my example below. In the first row there is an action called today. Create a data table of the key actions events first of all create a very simple data table with the high level actions and events that you want to track on the timeline. To create a timeline chart in excel take the following steps.

2 event name this column will contain event names. A rrange your data in columns in chronological order. Smartart creates a new graphic layout for you to add data. On the insert tab click smartart process. It does not transform your existing data so create a new blank spreadsheet for your timeline step 2 open the smartart menu. All you need to do is enter your project information and dates into a table and the excel timeline will automatically reflect the changes.