After you create the timeline you can add events move events change layouts and colors and apply different styles.

Create timeline from excel.

One of the benefits of using an excel project timeline template is that the formatting is already complete and all you need to do is customize it. 2 event name this column will contain event names. On the insert tab click smartart process. Click process in the smartart ribbon. 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. To create a timeline chart in excel you need the following three columns of data.

Click insert illustrations smartart process then from the template options and pick a timeline. To create a timeline in excel you will also need to add another column to your table that includes some plotting numbers. See my example below. This option is available in excel 2007 or later step 3 select the timeline from the process submenu. Scroll down in the spreadsheet and enter a start date. A rrange your data in columns in chronological order.

Click the project timeline field 1c at the top of the spreadsheet and enter your conference name. Depending on your version of excel either click the smartart tab in the ribbon menu or click the insert tab then the smartart button. In the first row there is an action called today. Click on the insert timeline button in the filter group. Here s the timeline we ll be creating in excel you can download the spreadsheet here zip 22kb. Excel will use these plotting points to vary the height of each milestone when plotting them on your timeline template.

In excel 2007 and 2010 click the timeline chart to activate the chart tools and then click the design save as template. 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 find microsoft s excel timeline design open microsoft excel and type timeline in the search window and then click enter. Smartart creates a new graphic layout for you to add data. It does not transform your existing data so create a new blank spreadsheet for your timeline step 2 open the smartart menu. 1 unit of time this column will contain units of time.

In excel 2013 right click the timeline chart and select the save as template from the right clicking menu. Step 1 create a new spreadsheet. To start your timeline open a blank excel page. Click on the insert timeline button in the filter group.