Without completely understanding what you want, off the top of my head I am
thinking you might be able to set the responses up in a pivot table to
analyze this. Hope this helps point you in the right direction.

"sasquatchbill" wrote:


I'm sorry if this is the wrong section of the forums, but I'm not sure
where to file this appropriately:

We're taking a survey that will hopefully have at least 1,000+
responses, and the responses will be exported to Excel. Each person
will first answer what role they have in our corporation, for instance:
Project Manager - Dev, Technical-Architect - Dev, Application-Owner -
Support, etc. The rest of the questions we want to chart are answered
with a 5 point scale from Poor - Very Good.

Our goal is to be able to chart the average answers for each Role, ie -
Application-Owner - Support average for question 5 is 'Good', while the
Tech-Architect average for Q5 is 'Poor'. The trick is that the data
comes into Excel as each question is answered - each row is a person
and their answers, with the columns being the questions.

The questions we have a
-How do we chart the averages of these different groups against each
other?
-Is there a way to separate the roles automatically, or will we have to
go through by hand and select their rows each after sorting them by
name?
-Will it be fairly easy to adjust the answers from Poor-Very Good into
1-5, and how is it done and where (in the chart parameters, or must it
be done on a worksheet?)

I think that's all - hopefully that made sense to you. We have barely
any idea how to do this, so any insight you can give us would help
immensely. If you need more/clearer info, please ask!!
Thanks!


--
sasquatchbill
------------------------------------------------------------------------
sasquatchbill's Profile: http://www.excelforum.com/member.php...o&userid=36550
View this thread: http://www.excelforum.com/showthread...hreadid=563011