Others

How to Export Microsoft Forms Results with Chart Data Labels to Word or PowerPoint

Bushra ParveenBushra Parveen Oct 29, 2026 871 views

Question details

The user needs a way to export Microsoft Forms survey responses and retain permanent chart data labels when presenting the data in Word or PowerPoint.

How to Export Microsoft Forms Results with Chart Data Labels
Product
Microsoft Forms, Microsoft Excel
Device & OS
not provided
Scenario
Compiling and presenting survey results from Microsoft Forms into fully formatted documents or slide presentations.
Observed behavior
Microsoft Forms built-in charts do not provide permanent data labels or allow direct export to fully formatted Word or PowerPoint graphics.
Before you start

Ensure you have access to the Microsoft Forms responses and have a spreadsheet application like Microsoft Excel or WPS Spreadsheet installed to process the exported data.

Solution 1Recommended

Export to Excel and Add Chart Data Labels Manually

The most reliable method to get formatted graphics is to export the raw data into Excel, create a custom chart with data labels, and then copy it to your destination file.

Since Microsoft Forms relies on dynamic web-based charts, it cannot directly send static charts with data labels to other programs. Creating the chart in a dedicated spreadsheet application gives you full control over the formatting.

1
Export Responses

Open your Microsoft Form, navigate to the 'Responses' tab, and click on 'Open in Excel' to download your response data.

2
Create a Chart

Open the downloaded Excel file, select the data you want to visualize, go to the 'Insert' tab, and choose your preferred chart type (e.g., Pie or Column chart).

3
Enable Data Labels

Click on the newly created chart, click the Chart Elements button (the '+' icon next to the chart), and check the box for 'Data Labels'.

4
Paste into Document

Right-click the formatted chart, select 'Copy', open your Word document or PowerPoint presentation, and paste it. Use the Paste Options to 'Keep Source Formatting' if necessary.

Export to Excel and Add Chart Data Labels Manually
Formatting Tip: You can further format the data labels in Excel by right-clicking them and selecting 'Format Data Labels' to show percentages or category names.
Process Forms Data in WPS Office

Create and Format Charts Easily with WPS Office

After downloading your Microsoft Forms data, you can use WPS Spreadsheet to create professional charts, add permanent data labels, and seamlessly copy them into WPS Writer or Presentation.

  1. 1. Open Exported Data: Download the Forms data as an Excel file and open it directly with WPS Spreadsheet.
  2. 2. Insert a Chart: Select your response data, go to the Insert tab, and choose a Chart type that fits your survey results.
  3. 3. Add Data Labels: Click Chart Elements and check the box for Data Labels to display values permanently on your chart.
  4. 4. Insert into Document: Right-click the formatted chart, select Copy, and paste it directly into your WPS Writer document or Presentation slide.
Seamlessly open Microsoft Excel (.xlsx) files exported from Forms without format loss.Add data labels and customize chart elements with a few simple clicks.Easily copy and paste charts across Spreadsheets, Writer, and Presentation natively.
microsoft office alternative - wps office

Frequently Asked Questions

Can I add permanent data labels directly in Microsoft Forms?

No, Microsoft Forms' built-in charts are designed to be interactive web elements. Hovering over them shows the data, but they do not currently support permanent, static data labels for direct export. You must export the data to a spreadsheet to format it.

How do I export Microsoft Forms data?

Navigate to the 'Responses' tab in your specific Microsoft Form and click the 'Open in Excel' button located on the right side of the screen. This downloads a file containing all raw response data.

Why does my copied chart lose its formatting in Word or PowerPoint?

When pasting a chart from a spreadsheet into a document, the destination program might apply its own default theme. Ensure you select 'Keep Source Formatting' from the Paste Options menu immediately after pasting to retain your data labels and original colors.

Can Power Automate generate charts directly from Forms responses?

Power Automate excels at exporting response text and numbers into Word or PDF templates. However, generating graphical charts dynamically within the flow typically requires advanced premium connectors or third-party charting APIs.