what is the best way to do this?

[mck]

I have data that I have exported from Access. The data is
over time and is a 27 question survey. There are also
over 30 departments. The questions have values of 1 -
yes, 2 - no, 3 - n/a and 0 blank.

I have to graph this data, per quarter (the date exported
from access is date entered) by department.

So I need a graph for each department for each question,
the values for each question and the data over time.

I'm not sure what the best way is to do this. Does anyone
have any suggestions?

Thanks for your help.
mck

 

[Nick Hodge]

mck

I would look to use a pivot table/chart combination. It's easiest to group
into quarters and you could use the 'count' function against the answers to
the various questions. Check it out in help and post back if you have any
issues.

Menu to access Data>Pivot table and Pivot chart report and select either
'External data' this will allow you to map it straight from Access or Excel
range if you want to import it first.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[mck]

I actually did try a pivot table - should I convert the
dates to quarters first? I'm afraid I'm still confused.

mck