Hi,
Trying to get lines to resize on an Excel sheet based on the 'Start Date' and the 'End Date' - this is all on the same row.
Can this be done with a formula? Or do I need to code?
Have a start line image, a continuous line image and an end of line image if this helps.
This is from a Gantt Chart I am building.
Almost certainly it requires VBA.
Have you considered using _ _ _ characters as a pseudo line and perhaps a REPT("_",n) where n is the days difference. Maybe use an IF() or Cond Format to supress the appearance of ____
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi, could this work?
Since the Start Date and the End Date are in date format and there is a function to convert the dates to Excel numbers could I not make a list of dates next to their numbers next to the cell references e. g. 18/10/21-formatted as Text to Column formatted as text and pasted into gives 44487.
Now I create lists of acceptable dates etc.... End_Date must be > Start_Date and so on making these 'date' drop-downs and put their chosen dates as numbers and I create a list of numbers to cell references i.e. 44487 | $D9 then i make it a big list that can be used as a VLOOKUP to give me the cells to hold my Start Line Image and End Line Image. Then I get the Continuous Lines images question. Is this possible?
I can't visualise what you're saying but there's nothing in what you say that should be a problem. This is different of course to your original post which was essentially asking how to manipulate a shape, in this case a line shape. That would require a macro.
Your description sounds unnecessarily complicated. I can't help thinking there will be simpler ways to achieve what you want, but to be able to advise further we'd need to see the data you start with, along with results that you have add manually so that we can understand the goal. Once we can see that we can advise of the optimum way to achieve it.
Hi,
Will provide a flow diagram showing what I am trying to achieve and a screenshot of what I have currently and this way you can recommend the Best way to achieve my aim.
No pictures, please!
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi,
Have attached a screenshot defining every section of my form.
Have attached a Flow Chart so you can see how a user would use it.
Finally I'll attach my workbook.
Can we precis this and say that for each task you have four dates
Expected Start & Expected End
Actual Start & Evaluated End
And the requirement is to show the duration of each of the Expected program and Actual program dates?
If so I suggest using the sort of shapes you show is making the whole task more complicated than it need be. Almost certainly a macro would be needed to position the shapes. It seems to me that you could use a symbol of some sort to record the 'bar' for the Expected program and conditional formatting to colour the cell for the Actual start and Evaluated dates.
I'm showing an example for the first task on the workbook attached.
I also changed the row 7 numbers to be proper dates so that formulae for the *** and the Cond Formats will work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks