Excel chart type

i have the following data in a spreadsheet:

PEOPLE WAGES SEX
ANNA $79,875.00 F
JENNY $5,668.00 F
LEANNE $4,678.00 F
JENNY $5,678.00 F
CHRIS $56,578.00 M
FRED $45,668.00 M
JEREMY $34,389.00 M
JOHN $67,909.00 M
PAUL $67,884.00 M

I would like to create a (bar?) chart that represents the above data and shows the Male(M) and Female(F) data as 2 different colours on the same bar of the chart.

Cheers…