Copy them all at once, but make sure not to include the column headers.

Excel Timeline Template Update A Timeline

If you need to create and update a timeline for recurring communications to clients and executives, it will be simpler and faster to create a PowerPoint timeline.

I will give you step-by-step instructions for making a timeline in Excel by formatting a Scatter chart.

Excel Timeline Template How To Instantly Create

I will also show you how to instantly create an executive timeline in PowerPoint by pasting from Excel.

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.

Excel will use these plotting points to vary the height of each milestone when plotting them on your timeline template.

This is where you will enter the plotting numbers you added to your table.

Click on the expansion arrow to get additional axis options for your chart.

Here you should uncheck Primary Vertical but leave Primary Horizontal checked.

Right-click on any one of the dates at the bottom of your timeline and select Format Axis to bring up Excels Format Axis menu.

Select No line, which will remove the horizontal lines around each of the plotted milestones on your timeline.

This will make connectors from your timelines milestones to their respective points on your timeband.

Uncheck Y Value, and then put a check next to Value From Cells.

To do this simply click on the description for the first milestone in your timeline table, (mine is Kick Off), then drag down to the last milestone in your timeline (mine is Sign Off).

In my example, I selected Vary colors by point, which lets Excel pick the milestone colors for my timeline.

Again select the paint can icon to choose Excels Line Fill options.

Well those set the height of each milestone on your timeline.

By adjusting these numbers, you can play around with different height positions for each milestone.

For example, to optimize my timeline, I used the number sequence, 1, 2, 3, 4, 1, 2, 3, 4.

Office Timeline is a PowerPoint add-in that instantly makes and updates timelines from Excel.

To begin you will need to install Office Timeline Plus, which will add a timeline creator tab to PowerPoint.

If you prefer to import and sync your Excel table, rather than copy-paste, click on the Import button in the preview window.

Excel Timeline Template For Mac