My group is using TFS for resource commitments. To get a clear overview of the project schedule I would like to use a Gantt chart in MS Project with 3 week sprint periods so we can see how we are doing against the delivery schedule. The 3 week period is easy but I cannot get the timescale to line up were I want it. I would also like to add labels for sprint #1,#2, etc...

  • 1
    It would be useful to explain what you've tried, and why that isn't working for you.
    – Todd A. Jacobs
    Mar 19, 2016 at 18:13
  • It is not clear from your question exactly what issue you are encountering. Can you please provide more information on which timescales are not aligning and in what respect. What do you require and what is actually happening? VTC as unclear in the meantime.
    – Marv Mills
    Mar 21, 2016 at 12:06
  • I think OP is looking for a way to (1) set the fine grained timescale on the gantt chart to 3 week intervals and (2) set the medium grained timescale to arbitrary units (sprint x, sprint x+1). I think (1) can be done with some fiddling & experimentation. I am dubious that (2) is possible without heroic work.
    – MCW
    Mar 21, 2016 at 17:55
  • @CodeGnome, I find that using MS Project in this way is usually the reason that things are not working and projects are late ☺ Mar 22, 2016 at 1:50

1 Answer 1


If you are looking to forecast sprints as part of Scrum then i would avoid the user of MS Project at all costs.

You would be better served looking at a Release Burndown or just simply projecting your known velocity onto you backlog.

The former can easily be plotted manually in Excel or on a physical board. It would take less than a minute each sprint to update and will give you better visibility and an understanding of progress towards your release goal.


While not an official artifact of the Scrum Guide, it is useful for Product Owners.

The later is a feature built into the Backlog tool in VSTS/TFS. If you go to the Backlog view you will see your historical velocity represented as a graph at the top of the screen. From this you can estimate both your mean, as well as pessimistic and optimistic, velocity. Then turn on the forecast option to draw lines for future sprints based on the velocity of your choice to get a rolling projection of where on your backlog you might get to.


These are both good planning visualisations that can help you project into the future. You have to let go of the old ways of project management (they don't work) and adopt some new ones.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.