Timeline Templates for Excel

A timeline can be a useful way to visualize changes or events that occur over periods of time. Excel can be a great tool for creating timelines, particularly when you want to perform date calculations or take advantage of the drawing tools in Excel. See below for some example timeline templates to help you get started.

Common Uses for Timelines

• Display a project schedule.
  - Deliverable dates - Milestones - Task completion -
• Chronologically arrange past events.
  - Innovations in science between 1800 and 2000 - World history -
• Represent a person's life history.
  - Depiction of life events along with historical time periods or local events -
• Map historic events and time periods.
  - History of the universe - Theory of evolution - Geologic time -

Vertical Timeline Using Shape Objects

for Excel

Download

⤓ Excel

For: Excel 2007 or later

Description

I like using Excel has a drawing canvas, especially for timelines, because the canvas is nearly infinite in size. A vertical timeline is easy to create using shape objects (lines, text boxes, callouts, etc.). You can use this template to give you a head start. Format a shape or callout the way you want and then use copy/paste to duplicate the shape and add your events.