ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Setting up segmented bar graphs (https://www.excelbanter.com/new-users-excel/91149-setting-up-segmented-bar-graphs.html)

spiketheone

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


excelent

Setting up segmented bar graphs
 
Hi Spike maby som like this :

http://pmexcelent.dk/Shart.xls


spiketheone

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


spiketheone

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


excelent

Setting up segmented bar graphs
 
Excel 2003 DK


excelent

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