Creating Excel reports using work item queries is one of the easiest ways to generate custom reports. Excel reports via a work item query let you generate status and trend graphs. Once the reports are generated, data can be manipulated by adding or filtering the fields using a PivotTable.
The following diagram shows the item count per member generated by a flat query list:
The following are the steps to generate Excel reports using a flat query list: