Prev: 01/00/00 appearing before date entered
Next: deleting info within a cell
From: tabithaIU on 9 Feb 2010 10:40
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
From: Pete_UK on 9 Feb 2010 12:05
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 <tabith...(a)discussions.microsoft.com>
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

From: Gord Dibben on 9 Feb 2010 12:39
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
<tabithaIU(a)discussions.microsoft.com> 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

 | 
Pages: 1
Prev: 01/00/00 appearing before date entered
Next: deleting info within a cell