How to create the Story Points vs Cycle Time Chart

In a recent post about measuring agile team effort, I showed you a graph I created using data from the backlog tool.

Here’s how I created it. I encourage you to do the same for your data.

It’s simple.

Pull this data from the backlog tool you use, for eg. Jira.

For each story that has been completed:

• start date - when the dev started work on the story

• end date - when the story was completed (including testing)

For each story, calculate the ‘Cycle Time’. I did this in MS Excel:

=DAYS(<closedDateField>, <startDateField>)

For me this was:

=DAYS(C2,B2)

Now, plot the story points and cycle time data in Excel using a ‘Box and Whiskers’ chart.

Let me know if you need further help.

Happy hunting.

---

---