Others

How to View Microsoft Forms Summary Results for a Specific Team

Emma BrownEmma Brown Nov 3, 2026 871 views

Question details

The user wants to view separate summary charts for a specific team out of all collected Microsoft Forms responses.

How to View Microsoft Forms Summary Results for a Specific Team
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Responses Tab

Navigate to your Microsoft Form and click on the 'Responses' tab located at the top of the form editing page.

2
Export the Data

Click on the 'Open in Excel' button to download all submitted form responses into a .xlsx file.

3
Apply Filters

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.

4
Create Custom Visualizations

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.

Export Responses to a Spreadsheet for Custom Summaries
Data Synchronization: The custom charts in your spreadsheet will not automatically sync with new incoming Microsoft Forms responses unless you set up a live data connection or periodically re-export the results.
Free Microsoft Office alternative

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. 1. Open Exported Data: Launch WPS Spreadsheet and open the .xlsx file downloaded from Microsoft Forms.
  2. 2. Filter by Team: Navigate to the Data tab, click Filter, and isolate the responses for your specific team.
  3. 3. Insert Summary Charts: Use the Insert tab to create a PivotChart that visualizes the filtered summary data perfectly.
100% compatible with Microsoft Excel (.xlsx) files exported directly from Microsoft Forms.Completely free, lightweight, and fast spreadsheet data analysis.Familiar user interface makes it easy to create PivotTables and filtered charts.Built-in templates for professional reporting and data visualization.
microsoft office alternative - wps office

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.