Visualize progress (work item charting)
You can quickly view the status of work in progress by charting the results of a flat-list query. You can create several types of charts—such as pie, bar, column, or stacked column—for the same query.
From the Queries page, open the chart editor for a flat list query.
Select the chart type and field for grouping values. When you use pie, bar, and column charts, select a single field to view a count of work items.
If you don’t see the field you want in the Group by drop-down list, add the field as a column to the query and save the query. You can group by any field except date-time and free-form text fields.
If you receive an error message when you close the chart editor, you need to request Full access.
Charts automatically update when you edit the query and when the results of the query change.
A: You need to have Full access in TWA to create and save charts.
A: When you select Area Path or Iteration Path, only the leaf node appears in the chart. The leaf node is the last node of the full path. For example, Phone is the leaf node of FabrikamFiber/Fabrikam Website/Phone. If your query contains a mixed level of leaf nodes, your chart might not reflect expected results.
A: No. Trend charts are not supported at this time. To create trend charts, open the query in Team Explorer and choose Create Report in Microsoft Excel.
A: The chart editor generates data from the work item tracking data store and therefore displays the most recent data. Excel PivotCharts access data published to the Analysis Services cube, which is refreshed every two hours by default.
A: If your team project has a project portal and SharePoint site configured, you can access several Excel charts. These include charts to monitor code quality, testing, and bug tracking activity.
A: If your team project has SQL Server reports added, you can access several reports that include status and trend activities.