Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Fidelio1st
 
Posts: n/a
Default Timeline: where it will match up data automatically

I'm trying to create a timeline for a screenplay I'm writing. I found a
nifty little template:
http://office.microsoft.com/en-us/te...162661033.aspx

But what I don't like is that I have to manually enter and move around the
events, and enter the years manually, etc.. I need to set up 3 different
timelines:

1. for 1 year, where each line on the timeline is a month
2. for 12 years, where each line is a year
3. a 60 year period, where every 2 lines is a decade, ie. from 1930's to
1990's

I want to make a chart where I enter the date and the event, then excel will
automatically make a box and put the event where it belongs on the timeline.
For example, I would make a chart like this for the year 2003:

Date Event
03/15/03 Intro Interview
05/05/03 Writer's Block
11/20/03 Chp. 4: Sales Meeting

Now instead of having to type each of these in the box in the template
(link) above, and then place them where they belong, I want to be able to
make a chart like the one above, and it automatically places it where it
belongs on the timeline (if I have to do each timeline separately, i.e. the
1,2,3 above, thats fine).

Any advice would be much appreciated, as I have a lot of events to place,
and if I can figure out how to do this, it will save time. Also, if you have
a suggestion for a better (free) program to use for this, that would also be
helpful. Thanks.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
match data to reference then vlookup lucky Excel Discussion (Misc queries) 0 February 8th 05 09:41 PM
need funct to match data in 3 seperate spreadsheets column 1 to v. lucky Excel Discussion (Misc queries) 2 February 8th 05 07:33 PM
Shuffling Data To Make Lists Match Dmorri254 Excel Worksheet Functions 1 January 14th 05 05:58 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Data Validation w/ If, Match & Index Statements Dominique Feteau Excel Worksheet Functions 2 December 18th 04 08:15 AM


All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"