Multiple Conditions on two columns

[Kyle]

I have two columns of a hundred rows. Column A represents
an answer to a survey question about a persons age group,
(answer range 1-5). Column B represents an answer to a
survey question, (range 1-4).

My goal is to create for each age group a percentage based
chart that shows their answers in cloumn B.

 

[Leo Heuser]

Thanks for telling us about your project.

 

[Tom Ogilvy]

in row1 of you date put in labels like

Age Choice

Select your data and do

Data=>PivotTable Report

Follow the wizard.

in the layout (in xl2000 and later, choose the layout button)

row field Age
Column Field Choice
Data field choice

If the datafield doesn't show Count of Choice, double click on it and change
it to Count

Now you can make a pie chart with each row of the pivot table.