View Single Post
  #1   Report Post  
Randhir
 
Posts: n/a
Default Gantt chart with labels

Hi - I am using Excel to create gantt charts by following the very helpful
instructions at:
http://office.microsoft.com/en-us/as...346051033.aspx. I am
struggling on two parts though:

1. How do I get the completion dates to show up on the bar? Just turning on
labels shows me the number of days not the date in the above example.

2. The month/time scale does not work for me - by setting the major step to
30 or even 61, the months start off fine - with jan 1, etc, but later through
the year, it goes off due to the difference in the number of days each month
resulting in Jan 1, Feb 3, Marc 6, etc. How do I get it to consistently show
the 1st of each month.

Thanks in advance for your suggestions.