Agile Charts for MS Excel

Very short post to catch those interested up.

I have produced some regular old Excel versions of my agile charts for distribution. Here’s a download link.

Charts Download

What’s here?

Excel Agile Charts!

Easy data entry and instructions for the charts below. Each file has instructions on how to read, update and use each version.

These are for real world use and you can edit and alter them as you please. Suggestions for improvement and a link back here would be nice!

Go for it.


Bug Tracking Chart



Sprint Burn Down Chart



Sprint Burn Up Chart



Cumulative Flow Chart



SPC Chart (Cycle Time)



Cycle Time Chart



Estimation Accuracy Over Time Chart



Forecast Lighthouse Chart



Spectral Analysis Chart



Time and Budget Chart (Earned value)



Have fun with these! Send me yours for inclusion and discussion here, and please suggest improvements. The more the better.


Add yours
  1. 6

    I seem to have issues getting a full download of the charts. I can get the “bug tracker” “burn down” “cycle time” and project forecast”. I thought I had downloaded the “burn up” chart, but it seems to be missing from the group. I would love to get my hands on it. These are great!

  2. 8
    Abhilash PMI-ACP

    This is really cool Stuff. Thanks a ton for sharing your wonderful work…
    I really loved the CFD and Bug Tracker
    Forecast seems interesting let me try this one out.
    One word AAAAMAZING

  3. 11

    I love the “Forecast Lighthouse Chart” and the “Time and Budget Chart”. Both really allow me to make better predictions and see potential problems early in the cycle. However, I’m wondering if there is a bug in the “Time and Budget Chart”. If I wind up having a sprint in which 0 points are completed (doesn’t happen often but does happen), the “Budget Spent” line moves appropriately (even if nothing was spent during that sprint) but the “Assumed Completed” line doesn’t update. I would expect that line to move horizontally (since no work was completed) but it doesn’t. When I complete points in my next sprint, it continues the line as if the 0 pointed sprint didn’t happen.

  4. 12

    this is probably an old thread… has there been an update to the Cycle time chart. I have some questions around the one I downloaded

Leave a Reply