SpreadsheetShoppe

  • Home
  • Downloads
    • Accounting Tools
    • Add-Ins
    • Business Tools
    • Calendars & Timelines
    • Graphs & Charts Templates
    • Lists Templates
    • Personal Finance
    • Project Management
    • Shortcut Keys
    • Stock Options
  • Useful Resources
  • Feedback/Upload
  • Blog

Timelines


Cost: Free
System Requirements: Microsoft Excel® 2003 or later*
User Agreement: Read it Here
Creator: SpreadsheetShoppe.com

+1 This Page
Description: 
We created a few timeline templates because these are simply a great tool for managing projects.  However, we've found several people like having these timelines to supplement their presentations - really these are good whenever you want to graphically reflect anything that's time based.  Below is a brief description of each timeline along with the download.  But first, here are some quick instructions in using these templates.

 

Picture
At the bottom of each timeline is a section that allows you to enter the dates and a description of the date (note, in some cases it's beneficial to put the date in both the date column as well as in the description).  Whatever is written in the Task column (i.e., date description) will be reflected on the timeline.  

The HT column is for the height of the date on the timeline and determines if the date is reflected on the upper portion or lower portion of the timeline.  Enter a positive number if you want it on the upper portion and a negative number for the lower portion.  

Our examples are setup in increments of 5, adjust as necessary.


Picture
Timeline Blue
File Size: 102 kb
File Type: xls
Download File

This timeline is set with a blue backdrop. Graphically display tasks, events, or other date oriented information.  You control the length of the bars, as well as the description that corresponds to each. This timeline has been formatted to hold up to 21 individual tasks.  Add additional tasks easily. 

Picture
Timeline Clear
File Size: 102 kb
File Type: xls
Download File

This template is just like the first, however, the backdrop is clear.  

Picture
Timeline Clear Scroll Bar
File Size: 103 kb
File Type: xls
Download File

Using the clear timeline, we added a scroll bar which makes the timeline dynamic.  Say you had 20 dates that you were tracking, but you only wanted the first 10 reflected on the timeline - by using the scroll bar you can "Hide" certain date and add them when necessary.
blog comments powered by Disqus

Other Useful Tools


Speedo Chart

Thermometer Chart

Project Management

Black Scholes


Question or comments?  Reach us Here

* Note, the coloring of this spreadsheet may look different when used with Excel 2003.

Microsoft® and Microsoft Excel® and Microsoft Word® are registered trademarks of Microsoft Corporation. SpreadsheetShoppe.com is not associated with Microsoft.