LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I fill labels in a chart, so that the grid lines don't in. peterk Charts and Charting in Excel 2 February 18th 05 01:52 AM
Labels on a chart Kevin Charts and Charting in Excel 1 February 10th 05 09:16 AM
Pie Chart Data Labels gb_S49 Charts and Charting in Excel 4 January 26th 05 02:37 PM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM
Gantt Chart with variable width columns - is this possible? Dave Charts and Charting in Excel 0 December 13th 04 08:00 PM


All times are GMT +1. The time now is 01:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"