| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
display answers to a questionnaire in a chart
A friend has a 12 question survey with a number of different answers
available. How do I display the different responses to the 12 questions in a single chart? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
display answers to a questionnaire in a chart
What type of answers?
Text strings like yes or no or similar? I think you would have to give the answers a number value then create your chart from those numbers. Use VLOOKUP on a table of answers and numbers to retrieve the number associated with a particular answer. Gord Dibben MS Excel MVP On Wed, 2 Jun 2010 04:48:01 -0700, Joanne Bryan <Joanne wrote: A friend has a 12 question survey with a number of different answers available. How do I display the different responses to the 12 questions in a single chart? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
display answers to a questionnaire in a chart
If you need help with this, email me your workbook.
change the AT and DOT to get my address. Gord On Wed, 02 Jun 2010 07:12:43 -0700, Gord Dibben <gorddibbATshawDOTca wrote: What type of answers? Text strings like yes or no or similar? I think you would have to give the answers a number value then create your chart from those numbers. Use VLOOKUP on a table of answers and numbers to retrieve the number associated with a particular answer. Gord Dibben MS Excel MVP On Wed, 2 Jun 2010 04:48:01 -0700, Joanne Bryan <Joanne wrote: A friend has a 12 question survey with a number of different answers available. How do I display the different responses to the 12 questions in a single chart? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Questionnaire - How can I automate the selected answers? | Excel Discussion (Misc queries) | |||
| How Do you send results of calc to seperate rows of answers to then later create chart | Excel Discussion (Misc queries) | |||
| How do I make a pie chart with 42 answers that shows % each out of | Charts and Charting in Excel | |||
| Can I display an Excel chart as my screensaver display? | Charts and Charting in Excel | |||
| What's the best chart style for graphing questionnaire response | Charts and Charting in Excel | |||
Hybrid Mode
