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

D

Del Cotter

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

Shane Devenshire

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

Combo Gant and Line Chart 4
How to create a bubble chart with more than 2 variables. 0
Showing Critcal Path in a Gant Chart 3
Resource Budget Cost - Tracking 0
can i link a MS Project gant chart to a MOSS 2007 sharepoint site 4
Weeknumbers 4
Creating a Chart on form from selected data in query. 0
Cannot see and gantt charts or other displays 0

Top