I am having a hard time understanding what you want to do and how you
want the data reported. How about an example that illustrates what you
want?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have a survey that I want to graph the answers to in a pie chart. However
the particpates could choose more than one response to the questions. These
means that each pie piece must be a percentage of the total surveyed not of
the total answers. I don't know if this is even possible. If you know how to
do this please let me know.