A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

display answers to a questionnaire in a chart



 
 
Thread Tools Display Modes
  #1  
Old June 2nd, 2010, 12:48 PM posted to microsoft.public.excel.worksheet.functions
Joanne Bryan
external usenet poster
 
Posts: 1
Default 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  
Old June 2nd, 2010, 03:12 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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  
Old June 2nd, 2010, 03:42 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.