Cumulative Flow Diagram Excel. Create your data in excel. Next begin collecting data.
To understand the distribution of work at any point in time just read the graph for that particular day. For example if your software development team s process has tasks moving through states of ready develop test and deployed then you might create an excel worksheet with columns like this. This diagram shows the count of backlog items and pace of their progress for the selected past number of days.
The in context report you can view from a team backlog or kanban board and the cfd widget you can add to a dashboard.
Creating a cumulative flow diagram in excel. This graph is a fundamental tool to visualize project progress and helps to spot potential problems. Create your data in excel. You use cumulative flow diagrams cfd to monitor the flow of work through a system.