How to View Microsoft Forms Summary Results for a Specific Team
Question details
The user wants to view separate summary charts for a specific team out of all collected Microsoft Forms responses.

- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- A single form has been used to collect responses from multiple teams, and the user needs to isolate and analyze the summary data for just one of those teams.
- Observed behavior
- Microsoft Forms only displays a combined summary for all responses on the Responses tab. Filtering the exported data in a spreadsheet does not update or recalculate the built-in summary charts on the Microsoft Forms website.
Ensure you have permission to view and export the responses from your Microsoft Form, and make sure a spreadsheet program like Microsoft Excel or WPS Spreadsheet is installed on your device.
Export Responses to a Spreadsheet for Custom Summaries
Since Microsoft Forms does not dynamically update its built-in summary charts based on filters, you must export the data to a spreadsheet to create custom charts for specific teams.
Microsoft Forms generates a static summary report based on all collected responses. The built-in dashboard cannot be filtered by team or individual fields. To analyze a subset of this data, you must export the records to a spreadsheet application, apply your filters there, and generate your own summary charts.
Navigate to your Microsoft Form and click on the 'Responses' tab located at the top of the form editing page.
Click on the 'Open in Excel' button to download all submitted form responses into a .xlsx file.
Open the downloaded spreadsheet. Highlight the header row, navigate to the 'Data' tab on the ribbon, and click 'Filter'. Use the dropdown arrow on your team column to select only the specific team you want to analyze.
Select the filtered data and go to the 'Insert' tab. Use the PivotTable or Chart options to build custom summaries that represent only the filtered subset of responses.

Analyze Form Responses with WPS Office
Need to filter and analyze your Microsoft Forms data without paying for an expensive subscription? WPS Office provides a powerful, free alternative to Microsoft Excel. You can seamlessly open exported form data, apply advanced filters, and generate professional summary charts.
- 1. Open Exported Data: Launch WPS Spreadsheet and open the .xlsx file downloaded from Microsoft Forms.
- 2. Filter by Team: Navigate to the Data tab, click Filter, and isolate the responses for your specific team.
- 3. Insert Summary Charts: Use the Insert tab to create a PivotChart that visualizes the filtered summary data perfectly.

Frequently Asked Questions
Can I filter the built-in summary charts directly in Microsoft Forms?
No, Microsoft Forms does not currently support filtering the built-in summary dashboard. The charts on the Responses tab will always display the aggregate data for all submitted responses regardless of any internal variables.
How do I set up a form so teams automatically have separate summaries?
If you require separate built-in summaries without using a spreadsheet, you must duplicate the original form and send a unique link to each team. This ensures each form's Responses tab only aggregates data for that specific group.
What is the best way to visualize filtered Microsoft Forms data?
The most effective method is to export the data to a spreadsheet program like Microsoft Excel or WPS Spreadsheet, format the data as a table, and use a PivotChart. This allows you to dynamically filter by team and instantly see the updated visualizations.




