Begin creating timelines in Excel within minutes by downloading the Excel Timeline Template. We've set up the data tables and Excel charts for you, so all you need to do is enter the Dates and event descriptions and adjust the heights of the lines to get things to fit just the way you want.
There are no hidden formulas, no hidden worksheets, no macros, and no VBA. You can change the colors and formats of the chart elements however you want, limited only by what Excel allows you to do.
Historical Timelines - The primary purpose of this template is to help you create historical timelines, such as events in a person's life or perhaps the history of a company or organization. These timelines use a year-based axis as shown in the Benjamin Franklin examples above. You can easily adjust the axis scaling just like you would any other Excel chart.
Project Timelines - The spreadsheet includes a project timeline example, where the horizontal axis is based on dates rather than years, and events can show both duration and completion status. You can adjust the date-based axis just like you do other Excel charts, so you can format the axis to show divisions each month, quarter, etc.
Adding Images - The Benjamin Franklin example is included in the spreadsheet, with instructions explaining how to insert images into your timeline. You will need to find and edit your own images.
Feedback - We are interested in your feedback. Please see our about/contact page (the link in the top-right corner of this page) to send us comments or questions about this template.
