Fever Chart Template in Excel

Use a fever chart to show progress toward project completion and to identify problems.

The Fever chart is one of many templates in QI Macros add-in for Excel.

You will find the Fever Chart Worksheet inside of the Theory of Constraints (TOC) template. Theory of Constraints argues that all of the buffer time should be at the end of the project, not in each step.

fever chart template

How to Create a Fever Chart using this template

  1. Open the "TOC Cloud and Reality Tree" template found in the "Diagrams" drop-down menu and select the "Fever Chart" tab:
  2. Fever Chart Tab

  3. Put % of critical chain completed in column A and % buffer time consumed in column B.
  4. Points in the green zone indicate the project is on or ahead of schedule. Red and yellow zones suggest the need for intervention.


To create a Fever Chart using QI Macros...
Try It Now!