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

BugTracking

 

Sprint Burn Down Chart

BurnDown

 

Sprint Burn Up Chart

BurnUp

 

Cumulative Flow Chart

CumulativeFlow

 

SPC Chart (Cycle Time)

CycleSPC

 

Cycle Time Chart

CycleTime

 

Estimation Accuracy Over Time Chart

EstimationAccuracy

 

Forecast Lighthouse Chart

lighthouse

 

Spectral Analysis Chart

SpectralAnalysis

 

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.

12 Comments

Add yours
  1. 6
    Lynda

    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
    Ken

    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
    kem

    Hello,
    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 to Jon Cancel reply