Setting up segmented bar graphs

I don't know if it can do it or if there is a program for it but I need to know how to set it up in Ecxel. A segmented bar graph is when the %'s are added up on top of one another.

Like I need male and female, and they answered yes or no. Well one bar for male ,answers of yes and no %'s on top=100% and the same for female.


________
no 25% |
_______|
yes 75%|
_______|
male...............Just in case

Hi Spike maby som like this :

http://pmexcelent.dk/Shart.xls

Dude that was great, thanks

I really like the 3-D look to it, what Excel are you running cause I have '03 version, I could just put my data in there to make it look 3-D, I'll try that. I didn't even see that option thanks, you saved me some trouble.

Excel 2003 DK

If u got the right version :

double click om red or blue bar
click on patterns tab
below all the colour sqares click on affects
make ur choise

sry bout the spelling

:-)