It does not transform your existing data so create a new blank spreadsheet for your timeline step 2 open the smartart menu.

Excel create timeline from data.

To create a timeline slicer your pivot table must contain a field where all data is formatted as a date. All values in the date field must be a valid date and formatted as such. To create a timeline in excel you will also need to add another column to your table that includes some plotting numbers. To apply timeline in excel first we need to create a pivot table. 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. Depending on your version of excel either click the smartart tab in the ribbon menu or click the insert tab then the smartart button.

Click on gantt project planner and click on create in the pop up window. 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. Add your information to the timeline in excel. The first section will guide you to prepare data for a timeline milestone chart creating in excel. 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.

See my example below. Add height values for each event in the column e. Click process in the smartart ribbon. Excel will use these plotting points to vary the height of each milestone when plotting them on your timeline template. Step 1 create a new spreadsheet. Then from the insert menu ribbon select timeline from the filters section.

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. This template was found using the latest version of excel on windows 8. Smartart creates a new graphic layout for you to add data. Double click on the excel project timeline template to open the spreadsheet.

Prepare a table and enter your original data as the following screen shot shown. To create a timeline slicer follow these steps. While opening it shows the options to select. To find an excel timeline template from microsoft open microsoft excel and type timeline in the search box and click enter. Search for gantt project planner to create project timeline in excel. 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.

It s not enough to have a column of data that contains a few dates. Click on the insert timeline button in the filter group.