In article ,
says...
How do I draw a gender-disaggregated age pyramid using MS Excel

Convert the values for one of the genders (male or female doesn't matter) to
negative numbers. Now, plot this converted data and the original data for
the other gender in a Bar (horizontal bars) sub type 'Stacked Bar'.

--
Regards,

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