Chart & Visualization Issues

How to Create Department or Location Survey Charts from Microsoft Forms

Algirdas Jasaitis Oct 10, 2026 869 views

Question details

The user wants to generate specific visual reports, such as pie charts, for sub-segments like departments or locations based on Microsoft Forms survey responses.

Product: Microsoft Forms / Microsoft Excel
Device & OS: not provided
Scenario: Visualizing and analyzing Microsoft Forms survey results segmented by specific demographics or groups.
Observed behavior: Microsoft Forms does not natively support creating pie charts for smaller response segments directly within its web interface.

Before you start

Ensure you have collected the necessary survey responses in Microsoft Forms and have a spreadsheet application installed to process the exported data.

Solution 1Recommended

Export Forms Data to Excel and Create a PivotTable Chart

Since Microsoft Forms lacks built-in segment filtering for charts, exporting the data to a spreadsheet allows you to use PivotTables to generate custom pie charts.

By downloading your raw survey data, you can leverage the advanced data analysis tools in spreadsheet software to cross-tabulate responses and build targeted visualizations for any segment.

Export Responses

Open your Microsoft Forms survey, navigate to the 'Responses' tab, and click on 'Open in Excel' to download your survey data as an .xlsx file.

Insert PivotTable

Open the downloaded file in Microsoft Excel or WPS Spreadsheet. Select your data range, go to the 'Insert' tab, click 'PivotTable', and place it on a New Worksheet.

Configure PivotTable Fields

In the PivotTable Fields pane, drag your segment field (e.g., 'Department' or 'Location') to the Rows area, and the specific survey question response field to the Values area to count the occurrences.

Create Pie Chart

With the PivotTable selected, navigate to the 'Insert' tab, click the 'Pie Chart' icon, and select your preferred 2D or 3D pie chart style to visualize the segmented data.

Export Forms Data to Excel and Create a PivotTable Chart

Data Updates: If you receive new survey responses after exporting, you will need to re-export the data and refresh your PivotTable to keep your charts updated.

Analyze Survey Data efficiently

Create Stunning Survey Charts with WPS Spreadsheet

WPS Spreadsheet offers powerful PivotTable and charting tools that seamlessly handle exported Microsoft Forms data, allowing you to visualize department and location metrics effortlessly.

1. Open Exported Data: Launch WPS Spreadsheet and open the .xlsx file downloaded from your Microsoft Forms Responses tab.
2. Insert PivotTable: Highlight your survey data, navigate to the 'Insert' tab on the top ribbon, and click 'PivotTable'.
3. Group by Department: Drag the 'Department' or 'Location' column header into the 'Rows' field, and drag the response column into 'Values' to aggregate the data.
4. Insert Chart: Go to the 'Insert' tab, select 'Chart', and choose a 'Pie' chart style to instantly visualize your segmented survey results.

Fully compatible with Microsoft Excel (.xlsx) formats exported directly from Microsoft Forms.Intuitive PivotTable drag-and-drop interface for quick survey segment analysis.Rich library of customizable pie, bar, and line charts for professional reporting.Lightweight, fast, and completely free to use as a Microsoft Office alternative.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Microsoft Forms show charts for individual departments natively?

Microsoft Forms is designed for quick, high-level summaries and only provides aggregate charts for all responses by default. It does not currently support cross-tabulation or filtering visual reports by specific segments like departments within its web interface.

Can I link my Microsoft Forms to update the spreadsheet chart automatically?

Yes, if you create the Form directly from Excel for the Web or a SharePoint team site, the data syncs automatically to the online workbook. You can build your PivotTables in that connected workbook, and they will update upon refresh as new responses arrive.

How do I change the chart type if a pie chart doesn't fit my survey data?

Once you have created your chart from the PivotTable, right-click the chart area and select 'Change Chart Type'. From the dialog box, you can easily switch to a Bar, Column, or Doughnut chart depending on what best represents your data segments.

Excel & Data Problems