I want to make a visual timeline in the spreadsheet; some sort of horizontal time axis (e.g. begining with week1 and ending with week 14). At the moment, each person in my project group has a list of deadline dates for different reports in a cell next to their name, and these deadline dates are indicated on the timeline by arrows with their name on it. At the moment, the arrows must be moved around manually to the date on the timeline.

What I need is for when a deadline date is entered next to a person's name, their arrow will automatically move along the timeline to that date. Pretty stumped at the moment, any fresh advice would help!