Chart & Visualization Issues

How to Create Pie Charts from Microsoft Forms Excel Responses

Aamir Naveed Akram Oct 12, 2026 868 views

Question details

The user wants to generate pie charts from raw Microsoft Forms survey responses exported to Excel.

How to Create Pie Charts from Microsoft Forms Excel Responses

Product: Excel
Device & OS: not provided
Scenario: Visualizing survey response data where each question is stored in a separate column.
Observed behavior: Creating a pie chart directly from the raw data produces one slice per respondent instead of aggregating the scores by question.

Before you start

Ensure your Microsoft Forms response data is exported to an Excel workbook and you have identified which columns contain the questions you want to analyze.

Solution 1Recommended

Reshape Data using Power Query and PivotTables

The most efficient way to aggregate survey data is by unpivoting the columns in Power Query to flatten the data, then creating a PivotChart.

Raw survey data usually features one row per respondent. To chart how many people selected each score, you must flatten the table so that questions and scores become manageable categories.

Load Data into Power Query

Select your data range, go to the Data tab, and click 'From Table/Range' to open the Power Query Editor.

Unpivot Other Columns

Right-click the column heading that contains the respondent's name or ID, and select 'Unpivot Other Columns'. This converts your wide data into three columns (e.g., Person, Attribute/Question, and Score).

Load Data to a PivotTable

Click 'Close & Load To...' on the Home tab, select 'PivotTable Report', and click OK.

Insert Pie Chart

In the PivotTable Fields pane, drag 'Attribute' (Question) to the Filters area, 'Value' (Score) to the Rows area, and 'Value' again to the Values area (ensure it is set to Count). Finally, go to Insert > PivotChart and select a Pie Chart.

Reshape Data using Power Query and PivotTables

Filtering by Question: Using the filter drop-down on your PivotChart, you can easily toggle between different questions to update the pie chart dynamically.

Solution 2

Aggregate Data using COUNTIF Formulas

If you prefer not to use Power Query, you can manually calculate the occurrences of each score using a summary table and COUNTIF formulas.

Efficient Data Visualization

Create Professional Charts Easily with WPS Office

WPS Spreadsheet offers powerful data analysis tools, including PivotTables, advanced formulas, and stunning chart templates, making it incredibly easy to visualize your survey data without complex software.

1. Open Survey Data: Open your exported Forms response file in WPS Spreadsheet.
2. Summarize Data: Use the built-in PivotTable feature or COUNTIF formulas to aggregate your response scores.
3. Insert Chart: Select the summarized data, navigate to the Insert tab, and choose a Pie Chart template.

Free and lightweight spreadsheet softwareFully compatible with Microsoft Excel (.xlsx) formatsRich library of 2D and 3D pie chart stylesIntuitive PivotTable and charting interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does my pie chart have one slice for every respondent?

This happens when you chart raw survey data directly. Because each row represents a single respondent, the chart draws a slice for every row. You must aggregate the data by counting how many people selected each specific score first.

Can I combine multiple Microsoft Forms questions into a single pie chart?

Yes. If the questions share the same scoring scale, you can unpivot multiple question columns together in Power Query, or use combined COUNTIF formulas (e.g., =COUNTIF(C:C, 5) + COUNTIF(D:D, 5)) to aggregate the total responses across all selected questions.

What if my survey answers are text instead of numbers?

The PivotTable method handles text effortlessly. When you drag your text answers into the 'Values' field of the PivotTable, it will automatically default to 'Count', giving you the total number of times each text option was selected.

Excel & Data Problems