Monday, September 19, 2011

How to Create a Simple Timeline with Excel


1. Open a Web browser. Go to Microsoft.com and conduct a search for 'Excel timeline template.' From the resulting list, find the template titled 'Timeline' for Excel 97 or later.
2. Download the template. Select the template link, which will take you to the template's Web page. Click 'Download Now,' accepting any Web browser prompts regarding downloading a file. Excel should open with the template selected.
3. Modify the template. Select the years along the timeline and change them to relevant dates. Make sure that your dates make sense for the timeline. Copy and paste text boxes to create new events, and modify existing text boxes as necessary. Move them by left-clicking and dragging to the right location. Copy and paste the lines that connect the events to the timeline, and move them as required.
4. Delete the instructions. Once you are familiar with how to manipulate the template, delete the instructions by selecting the text box and hitting 'DEL.'
5. Save the file. Select 'File,' and then 'Save As...', and give the file a name and location. In Excel 2007, select the Office Button and then 'Save As.'

Blogger news