Moving shapes based on date range (project timeline)

[crtk09]

Hey all,

I'm building a collection of very high-level project timelines for a quick snapshot of where a project currently stands. This is all based on the dates / date ranges I'm given by Project Managers, and then have to manually extend and move the visual timeline references around.

*Edit* - I don't seem to be able to include the shapes with xl2bb. Please see image below table for visual ref.

I was wondering if there is a smarter, more automated way to accomplish this. I don't know if what I'm asking is too much because of the shapes all being on the same line, rather than stacked on top of one another.

Here's a dummy example of what I am currently doing. There's two timeline examples there:

Project	Commissioning	UAT	Shadowing	Go Live	Target Project Completion		Feb-2022	Mar-2022	Apr-2022	May-2022	Jun-2022	Jul-2022	Aug-2022	Sep-2022	Oct-2022	Nov-2022	Dec-2022	Jan-2023
Software Enhancement	Not Required	2/15/2022	3/3/2022	3/10/2022	3/15/2022
Project	Commissioning	UAT Started	UAT End	Shadowing Start	Shadowing End	Go Live	Target Project Completion	Feb-2022	Mar-2022	Apr-2022	May-2022	Jun-2022	Jul-2022	Aug-2022	Sep-2022	Oct-2022	Nov-2022	Dec-2022	Jan-2023
Software Enhancement	Not Required	2/1/2022	2/15/2022	2/16/2022	3/3/2022	3/10/2022	########

Tl;dr - Can I "link" shapes to a date range? (VBA, formulas...) Either based on a start/end date, or possibly the number of days stated, and then have them extend/lengthen? I guess an "anchor" starting point would need to be defined, followed by the end date...

 

[Micron]

All I can think of, assuming I even remotely grasp what you're saying, is to use the Left property of the shape you want to move. It's position would have to be calculated and be relative to something but I have no idea what that is. Another shape? A cell border? Relative to the left window border? If not to another shape, then I suspect there will be issues when/if someone alters a column width.