![]() |
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 -- spiketheone ------------------------------------------------------------------------ spiketheone's Profile: http://www.excelforum.com/member.php...o&userid=34911 View this thread: http://www.excelforum.com/showthread...hreadid=546520 |
Setting up segmented bar graphs
|
Setting up segmented bar graphs
Dude that was great, thanks -- spiketheone ------------------------------------------------------------------------ spiketheone's Profile: http://www.excelforum.com/member.php...o&userid=34911 View this thread: http://www.excelforum.com/showthread...hreadid=546520 |
Setting up segmented bar graphs
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. -- spiketheone ------------------------------------------------------------------------ spiketheone's Profile: http://www.excelforum.com/member.php...o&userid=34911 View this thread: http://www.excelforum.com/showthread...hreadid=546520 |
Setting up segmented bar graphs
Excel 2003 DK
|
Setting up segmented bar graphs
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 :-) |
All times are GMT +1. The time now is 09:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com