A microsoft excel template is especially useful if you don t have a lot of experience making a project timeline.

Make a timeline on excel.

In the first row there is an action called today. Click on the insert timeline button in the filter group. Now just drag the bar right to left as per need to filter the data with time. 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. Depending on your version of excel either click the smartart tab in the ribbon menu or click the insert tab then the smartart button. Create a data table of the key actions events.

All you need to do is enter your project information and dates into a table and the excel timeline will automatically reflect the changes. It does not transform your existing data so create a new blank spreadsheet for your timeline step 2 open the smartart menu. Smartart creates a new graphic layout for you to add data. The easiest way to make a timeline in excel is to use a pre made template. First of all create a very simple data table with the high level actions and events that you want to track on the timeline. This will be used to create a line on the chart marking today s date.

To apply timeline in excel first we need to create a pivot table. This option is available in excel 2007 or later step 3 select the timeline from the process submenu. Click process in the smartart ribbon. Step 1 create a new spreadsheet. In the charts section of the ribbon drop down the scatter or bubble chart menu. Then from the insert menu ribbon select timeline from the filters section.

Then from the excel ribbon select the insert tab and navigate to the charts section of the ribbon. Click on the insert timeline button in the filter group. Then click right on timeline and from the report connections choose the fields which we want to connect with timeline.