Help for Excel Chart problem

F

Flame

Hi I have a little problem.
I have to prepare audience profile for some TV Channels using
dimensions age, sex, monthly income and education.
I want to combine metric - age and income in one chart and non metric -
sex and education in other.
So I dont know which chart to use. I think the most appropriate is the
bubble chart (more I have the penetration as a bubble size).
But I cannot think how to dispose the dimensions and data.

Example: Channel 1
Age
12-18 30 %
19-34 20%
35-64 35%
64+ 15%

Sex
Male - 48%
Female - 52%

So I need to positioning this channel and compare with others.

Please if anyone knows hot to make that I`ll be very thankful.

Flame
 
Top