Yes you can, sort of, you can not get the dividing line.

Add two more series to the chart with series name of Male and Female.
Change the sort order so they are at the top. Format the fill and border
of the 2 series to none.

You will need to re size the legend to get the layout of a 2 column 3
row legend.

Cheers
Andy

vb_4_net wrote:
Hi
I wanna format my chart like this one:
http://i10.tinypic.com/2eghct5.jpg

Kindest regards



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info