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.
