Forum Discussion
Multiple Answer "Choice" Answers not Populating Excel Spreadsheet
I created a Form through OneDrive using Forms for Excel that had two "checkbox" multiple-choice questions. To clarify: two "choice" questions that allowed users to choose multiple options for each.
Two questions related to this:
1. Is there a way to toggle my visual data results between pie or bar charts? The pie charts are not very useful to me, but a bar chart would help a lot.
2. The Excel file generated from these results is completely empty. There is no header row with the questions...just nothing. Where I would expect to see a sheet named "Form 1," I instead see a sheet named "_56F9DC9755BA473782653E2940F9," and again, it is entirely empty. Is this because of the question type, or is there something else going on here? And if it is the question type, is there a plan in the works to allow that data to be viewed in an Excel workbook?
Thanks,
Brian
1 Reply
- Have you tried using Microsoft Forms? It is ultimately supposed to replace Excel forms/surveys and has some great additional functionality.