Setting up segmented bar graphs

[spiketheone]

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

 

[excelent]

Hi Spike maby som like this :

http://pmexcelent.dk/Shart.xls

 

[spiketheone]

Dude that was great, thanks

 

[spiketheone]

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

 

[excelent]

Excel 2003 DK

 

[excelent]

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