In the first row there is an action called today.

Creating a timeline in excel.

2 event name this column will contain event names. A microsoft excel template is especially useful if you don t have a lot of experience making a project timeline. Step 1 create a new spreadsheet. It does not transform your existing data so create a new blank spreadsheet for your timeline step 2 open the smartart menu. Create a data table of the key actions events. 1 unit of time this column will contain units of time.

The easiest way to make a timeline in excel is to use a pre made template. Here s the timeline we ll be creating in excel you can download the spreadsheet here zip 22kb. Then click right on timeline and from the report connections choose the fields which we want to connect with timeline. Excel tutorial on how to make a timeline in excel using smartart that you can use to show milestones or key events. We ll make 2 timelines using a list of ye. Click on the insert timeline button in the filter group.

This option is available in excel 2007 or later step 3 select the timeline from the process submenu. Excel will use these plotting points to vary the height of each milestone when plotting them on your timeline 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. Now just drag the bar right to left as per need to filter the data with time. Click on the insert timeline button in the filter group. This will be used to create a line on the chart marking today s date.

See my example below. If you want to create a graphical representation of a sequence of events such as the milestones in a project or the main events of a person s life you can use a smartart graphic timeline. All you need to do is enter your project information and dates into a table and the excel timeline will automatically reflect the changes. To apply timeline in excel first we need to create a pivot table. To create a timeline in excel you will also need to add another column to your table that includes some plotting numbers. Smartart creates a new graphic layout for you to add data.

Search for gantt project planner to create project timeline in excel click on gantt project planner and click on create in the pop up window. Then from the insert menu ribbon select timeline from the filters section. 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. 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. After you create the timeline you can add more dates move dates change layouts and colors and apply different styles. The template is ready to start by entering your project details in the given column as per the headers and see the bars reflecting the timeline.

Depending on your version of excel either click the smartart tab in the ribbon menu or click the insert tab then the smartart button.