how to format a 12 mo. calender and gant chart to track projects

  • Thread starter Thread starter Jeff Dugan
  • Start date Start date
i am trying to format a 12 month calender and gant chart to track projects.
Click to expand...

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a freeware application for creating gant charts in excel 1
How to create a bubble chart with more than 2 variables 0
Word Count to include an Object 2
...can my public folder calender's events be linked to spread shee 1
Gant charts 2
Gant Charts for MS Access 2
need a function (UDF) return X if 2 dates fall between 2 other dates 4
Graphing Data 1

Back
Top