Gannt Bar Formatting

[C Scull]

I have added the Start and Finish on the left and right of the Bar. I would
like these dates to be in work week format like w1, w2, ...w52 as are my
Start and Finish columns. Like my selection of Timescale.

 

[JackD]

Use a custom field for this.

I use the following formula in one of the text columns to show workweeks:

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy")

Then instead of adding start and finish, add the text field as the source
for the bar text.
With this approach you can also add additional information - say if you want
it to show the ww finish AND the resource names then simply amend the
formula to be:

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy") & " "
& [Resource Names]

 

[JulieS]

Hi Jack,
Brilliant! I *always* learn so much from your posts!
Julie

Use a custom field for this.

I use the following formula in one of the text columns to show workweeks:

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy")

Then instead of adding start and finish, add the text field as the source
for the bar text.
With this approach you can also add additional information - say if you want
it to show the ww finish AND the resource names then simply amend the
formula to be:

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy") & " "
& [Resource Names]

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

I have added the Start and Finish on the left and right of the Bar. I would
like these dates to be in work week format like w1, w2, ...w52 as are my
Start and Finish columns. Like my selection of Timescale.

 

[JackD]

Thanks. Custom fields are one of the most powerful features of project.

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

Hi Jack,
Brilliant! I *always* learn so much from your posts!
Julie

Use a custom field for this.

I use the following formula in one of the text columns to show workweeks:

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy")

Then instead of adding start and finish, add the text field as the source
for the bar text.
With this approach you can also add additional information - say if you want
it to show the ww finish AND the resource names then simply amend the
formula to be:

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy") & " "
& [Resource Names]

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

I have added the Start and Finish on the left and right of the Bar. I would
like these dates to be in work week format like w1, w2, ...w52 as are my
Start and Finish columns. Like my selection of Timescale.

 

[NinjaPilot]

Jack,

I've been wrestling with the problem of 'combined' Bar Text since I can
remember!!
I just settled for adding a Text Box to convey my additional information.
But I've just tried your 'Custom Field' thingy and it worked a treat!!!!!!
Yipee,

Gary

Thanks. Custom fields are one of the most powerful features of project.

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

Hi Jack,
Brilliant! I *always* learn so much from your posts!
Julie

Use a custom field for this.

I use the following formula in one of the text columns to show workweeks:

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy")

Then instead of adding start and finish, add the text field as the source
for the bar text.
With this approach you can also add additional information - say if you want
it to show the ww finish AND the resource names then simply amend the
formula to be:

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy") & " "
& [Resource Names]

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..
I have added the Start and Finish on the left and right of the Bar. I
would
like these dates to be in work week format like w1, w2, ...w52 as are my
Start and Finish columns. Like my selection of Timescale.