Survey results to pivot with pie charts

[HURTMYPONY]

I have the results of a survey that looks a little like this:

The "Store column" has 8 different store names, and the "job function" up to 9 different job titles.

The columns go on to cover 40 questions, with 7 degrees of responses (Strongly Disagree all the way to Strongly Agree).

Thanks to management's "feature creep", they would now like it broken down by "Dealer" and "Job Function", with some pretty pies or graphs to boot.

I figured a filtered pivot table would be the best way to do this, allowing them to view the preferred combinations of "job function" and "dealer", and then tie 40 pie charts into it (one for every question) that would dynamically change based on their filter choice combinations.

But I am new to Excel 2007, and cannot understand the new pivot options enough to make it happen.

I am sure this is possible. Can anyone give me a few tips?

Thank you very much!

 

[HURTMYPONY]

Ah, no one is able to help me with this? Sorry for the bump, I am desperate...

I get the pivot looking as it should, but I am doing something wrong because it is failing to total the rows properly. The frustrating thing is it would probably be 5 minutes of work in Excel 2003 for me, but I no longer have a copy...