I am getting closer with:


IIf(DateDiff("d",[Start],[Finish])+1-len([Name])>0,Space(3*DateDiff("d",[Start],[Finish])+1-len([Name])) & [Name],[Name])

I am beginning to understand this code a bit better. The issue I see is the 3x multiplier is dependent on the timescale you're using. SPACE returns a number that is used to create a blank section prior to writing the NAME. The blank space is a number of spaces as returned by the SPACE function. But the length of the space is probably not the same length as a 'day' represents on the gantt chart again depending on the time scale being used. In my case, where my time scale is very compressed I had to actually divide the number of spaces returned to get the text to fit on the bar.

I would hope there is a way to account for the time scale.