Hi.
I have found my self stuck trying to create this.
Effectively what I'm trying to create is a timeline that can copy down along the side of a table as a visual aid to the data in the table. I have tried many things like converting dates to numbers, then dividing them by 365, then trying to turn them into percentages but nothing I do is working.
My experience with using charts is very limited and while I'm not bad at Excel logic, after about 6-8 hours I'm really not getting anywhere. Since this isn't for work either I feel like I am just wasting my time even though I can see that achieving this would be really useful.
I have attached a sheet which shows a general idea of what I'm trying to achieve. If anyone can solve this for me you will be a hero.
Bookmarks