Skip to main content
2 of 2
Remove software recommendation request. Refocus on scheduling and charting from Excel.
Todd A. Jacobs
  • 50.7k
  • 7
  • 60
  • 181

How can I create a visual timeline of User Stories / Epics from an Excel spreadsheet?

Ideally, I'd like to use an Excel spreadsheet to generate the following for me from columns of "User Story", "Start", and "End". Even if it didn't take it from the spreadsheet and I had to enter all the epics in manually, it would be better than manually creating all those dang boxes and moving them around.

enter image description here

In the diagram above, the columns titles indicate the bi-weekly sprint. "1507-2" just means 2nd half of July 2015, it's a shorthand used forever to communicate our entire company, to avoid ambiguity of saying "Sprint 17".

What I'm looking for is essentially a Gantt chart, but just a friendly version. How can I generate this type of chart from Excel?

TMC
  • 111
  • 2