Creating an Excel chart from multiple variables

[LLively2]

We have 2 columns

A = Age groups - 7 different age groups denoted by 1 or 2 or 3
or 4 or 5 or 6 or 7
B = Gender - Denoted by 1=M and 0=F

Sample Data:

Age Groups Gender
1 0
3 1
4 0
7 0
3 0
4 0
6 1
1 1
7 0
3 1
4 1
5 0
6 0
7 0
7 1
6 0
5 1
4 0
1 1
2 1
3 1

We would like the chart to display the 7 Age Groups and what
percentage of the age groups are M or F.

Thanks in advance,

Lynn

 

[macropod]

Hi LLively2,

You've posted this in a Word vba newsgroup, but your question doesn't seem to have anything to do with Word. Try:
microsoft.public.excel.charting.