Vertical Timeline

Hello,

I'm trying to create some sort of vertical visual timeline, based on start and finish dates defined for each project as entered in the attached file. I'm thinking Vba but there may be a simpler option?

So based on the durations, I'd like a coloured column which would define the duration of each project, something like what I've manually done in the attached.

One issue I'm not sure how I'll handle yet is that some tasks will overlap but if I can get the above working in some form, I will look at addressing this.

Thanks.

Hi there,

I couldn't see a fellow Irish(wo)man stuck for a solution!

The non-VBA approach is impressive, but if you DO want to go down the VBA road the attached workbook might get you moving in the right direction:

Please Login or Register  to view this content.

The highlighted values can be altered to suit your own requirements.

These values are the names of defined ranges on the worksheet.

Hope this helps - please let me know how you get on.

Regards,

Greg M