Moving shapes based on date range (project timeline)

crtk09

New Member
Joined
Dec 17, 2021
Messages
16
Office Version
  1. 365
Platform
  1. Windows
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:
ProjectCommissioningUATShadowingGo LiveTarget Project CompletionFeb-2022Mar-2022Apr-2022May-2022Jun-2022Jul-2022Aug-2022Sep-2022Oct-2022Nov-2022Dec-2022Jan-2023
Software EnhancementNot Required2/15/20223/3/20223/10/20223/15/2022
ProjectCommissioningUAT StartedUAT EndShadowing StartShadowing EndGo LiveTarget Project CompletionFeb-2022Mar-2022Apr-2022May-2022Jun-2022Jul-2022Aug-2022Sep-2022Oct-2022Nov-2022Dec-2022Jan-2023
Software EnhancementNot Required2/1/20222/15/20222/16/20223/3/20223/10/2022########


1654009965062.png


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...
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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.
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top