i am trying to format a 12 month calender and gant chart to track projects.

On Sat, 19 Apr 2008, in microsoft.public.excel.charting,
Jeff Dugan said:

i am trying to format a 12 month calender and gant chart to track projects.

The most important columns to have are "Task name", then "Task start
date" and "Length of task in days". Create a stacked bar chart and
format the "task start date" bar to be invisible. The "length of task in
days" bar will then be floating in the middle of the chart. Reverse the
order of the name axis in Format Axis, so the task names read top to
bottom instead bottom to top.

Google "gantt-charts excel" for examples.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Hi Jeff

MS Project would be the best choice. You can make a gantt chart in Excel
but it's pretty poor. You can google Excel Gantt charts for examples.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Jeff Dugan" <Jeff wrote in message
...
i am trying to format a 12 month calender and gant chart to track
projects.