creating a graph from a drop down menu
 

Hi,
I have to create a database that will be used to analyse some questionnaire
and have made a spreadsheet where the answers to the questions (which within
the questionnaire are on a strongly agree - strongly disagree rating scale)
are in a drop down menu. I was wondering if I would be able to make a graph
from this data?
Cheers

creating a graph from a drop down menu
 

Well, the short answer is yes, but how this is accomplished depends on
how your data is structured. Essentially, you will need 5 or 7 cells
which will contain the number of responses in the categories from
Strongly agree to strongly Sisagree for the question that you choose
from the pull-down. Those cells will contain formulae to count the
responses in each category for the selected question - a SUMPRODUCT
formula. Your graph will then be drawn from the numbers in those
cells.

Perhaps you can provide a few more details showing what data you have
and how it is arranged.

Hope this helps.

Pete

On Feb 9, 3:40*pm, tabithaIU
wrote:
Hi,
I have to create a database that will be used to analyse some questionnaire
and have made a spreadsheet where the answers to the questions (which within
the questionnaire are on a strongly agree - strongly disagree rating scale)
are in a drop down menu. I was wondering if I would be able to make a graph
from this data?
Cheers

creating a graph from a drop down menu
 

In an adjcent column assign a numerical value to each of your choices using
Lookup or similar function.

Graph on that column.


Gord Dibben MS Excel MVP

On Tue, 9 Feb 2010 07:40:01 -0800, tabithaIU
wrote:

Hi,
I have to create a database that will be used to analyse some questionnaire
and have made a spreadsheet where the answers to the questions (which within
the questionnaire are on a strongly agree - strongly disagree rating scale)
are in a drop down menu. I was wondering if I would be able to make a graph
from this data?
Cheers