Dynamic Charts with sub-groups?
 

I frequently create dynamic charts via look-up tables using Excel 2007. I
want to create dynamic charts capable of displaying results for different
types of sub-groups without having blanks or zeros appearing in the chart.
As an example, I want to create a dynamic chart that charts 4 age groups or 2
gender groups (but the gender chart cannot have any blanks or zero/NA fills).
I have to think there's a way around it but my Excel skills aren't that
advanced.