Chart & Visualization Issues

How to Filter Microsoft Forms Survey Results by Group

Maira Mehtab Sep 22, 2026 869 views

Question details

The user wants to generate a chart displaying Microsoft Forms survey results for a single specific group, rather than viewing the combined responses of all groups.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Visualizing and analyzing survey data for a specific demographic or segment to gain targeted insights.
Observed behavior: Microsoft Forms displays combined results for all respondents by default, offering no built-in feature to filter the native results charts by specific groups.

Before you start

Ensure you have finished collecting responses in Microsoft Forms and have a spreadsheet application installed to process the exported data.

Solution 1Recommended

Export Data and Filter in a Spreadsheet

Since Microsoft Forms lacks native filtering for its summary charts, you must export the response data to a spreadsheet application to filter the groups and manually create your charts.

Microsoft Forms is designed to provide a broad overview of survey data. For granular analysis, such as isolating responses from a specific group, the data must be exported.

By utilizing a spreadsheet program, you can apply filters to the raw data and generate highly customized charts that meet your specific reporting needs.

Navigate to Forms Responses

Open your survey in Microsoft Forms and click on the 'Responses' tab located at the top of the page.

Export the Survey Data

Click the 'Open in Excel' button to download your raw survey responses as an .xlsx file to your local computer.

Apply a Data Filter

Open the downloaded file in your spreadsheet software. Select the column header that contains your group identifiers, navigate to the 'Data' tab on the ribbon, and click 'Filter'.

Isolate the Target Group

Click the filter drop-down arrow on the group column and uncheck the boxes for any groups you wish to exclude, leaving only your target group checked.

Create a Custom Chart

Highlight the filtered data you wish to visualize, go to the 'Insert' tab, and select a chart type (like a pie or bar chart) to display the results for that specific group.

Live Data Updates: A standard download creates a static offline file. If your survey is still receiving responses, you will need to re-export the data periodically to update your custom charts.

Process Survey Data Efficiently

Filter and Visualize Survey Data with WPS Spreadsheet

After downloading your Microsoft Forms results, you can use WPS Spreadsheet to effortlessly filter your group data and generate professional, customized charts.

1. Open the Forms Data: Launch WPS Spreadsheet and open the .xlsx file you downloaded from Microsoft Forms.
2. Enable AutoFilter: Select the header row of your data, navigate to the 'Data' tab, and click the 'AutoFilter' button.
3. Filter the Group: Click the drop-down menu on the column containing your groups and select only the group you want to analyze.
4. Insert a Chart: Highlight the specific filtered response columns, go to the 'Insert' tab, and choose your preferred chart type to visualize the data.

Fully compatible with Microsoft Excel (.xlsx) formats exported from FormsAdvanced charting tools to visualize segmented survey data clearlyBuilt-in AutoFilter feature for quick and easy data sortingFree and lightweight alternative to heavy data analysis software

Frequently Asked Questions

Can I share the filtered chart directly from Microsoft Forms?

No, because Microsoft Forms does not support native chart filtering, you cannot share a filtered view directly from the platform. You must share the customized chart you create in your spreadsheet software.

Why doesn't Microsoft Forms allow filtering directly on the results page?

Microsoft Forms is built to provide a rapid, high-level summary of all collected data. For complex segmenting and cross-tabulation, Microsoft relies on the advanced data manipulation capabilities of spreadsheet applications.

Will my exported spreadsheet chart update automatically when new responses arrive?

If you simply click 'Open in Excel' on a standard form, it downloads a static copy of the data. To have live-updating charts, you need to create the form originally from within OneDrive or SharePoint, which maintains a live-syncing workbook.

Excel & Data Problems