Search results

Hello! I am trying to sort this gantt chart by project milestone. https://dl.dropbox.com/u/28669516/Project%20Tracking%20-%206%20Mo.%20Calendar%20-%20Sortable.xlsx If I sort by End, there are two problems I encounter. 1st problem: The project length and milestone end date are in the same...

Faseeh, Thanks for the message. When I try to filter as you suggested I get an error that "all merged cells must be identically sized to perform this operation". I tried unmerging but that breaks the spreadsheet. Also tried sorting instead of filtering, but it breaks the projects apart. Is...

UPDATE: I modified this fantastic spreadsheet that does almost exactly what I want it to. http://office.microsoft.com/en-us/templates/project-plan-gantt-chart-TC030009340.aspx One problem: What is the best way to sort this calendar by due date? Should I create a macro that allows you to...

Faseeh, Thanks for the reply! Yes, I thought about doing a sheet as you suggest, but I don't know if that will fit one page. I also don't know how to handle different types of projects: some have multiple stages/milestones, and others just have one deliverable. As to your understanding; I...

Hello! I am trying to create a chart that displays milestones for over 50 projects. This will be used as a snapshot to show duration of project stages, as well as final project deadline and forecast of entire project timeline. The purpose is to summarize what projects have what items due in the...