tag:blogger.com,1999:blog-7958828565254404797.post5744944232883683377..comments2024-03-29T00:02:14.892-07:00Comments on ListenData: Count and Percentage in a Column ChartDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-7958828565254404797.post-34417457311186772172022-04-04T22:59:54.315-07:002022-04-04T22:59:54.315-07:00This is great!
Can you please show how to do this...This is great! <br />Can you please show how to do this with a stacked bargraph?<br />Anonymoushttps://www.blogger.com/profile/10940372431804819262noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-49121989382177238532022-02-03T02:02:11.164-08:002022-02-03T02:02:11.164-08:00Sir can you make a video tutorial of this. I think...Sir can you make a video tutorial of this. I think this is outdated with the nwe version of Excel 360. Thanks in advance!ineedanswershttps://www.blogger.com/profile/08817971086304032039noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-41309172991723359572021-10-25T10:40:39.084-07:002021-10-25T10:40:39.084-07:00How did the first bar graph disappear?How did the first bar graph disappear?Anonymoushttps://www.blogger.com/profile/15044807517038081803noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-10355816877146478042021-10-25T10:38:49.790-07:002021-10-25T10:38:49.790-07:00So, the value represents that percentage right? So, the value represents that percentage right? Anonymoushttps://www.blogger.com/profile/15044807517038081803noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-21233716251196009012021-05-15T05:04:43.725-07:002021-05-15T05:04:43.725-07:00Hi Deepanshu,
I downloaded work sheet for value a...Hi Deepanshu,<br /><br />I downloaded work sheet for value and percentage column. I entered the details in sheet and prepared the graph and pasted the graph in word document. While when entering the details in next time word document gets automatically updated and therefore, not able to make different graphs using the same work sheet. Every time it is getting updated.<br /><br />Kindly help<br /><br />Regards,<br />Abhishek,<br />7330886629<br />Anonymoushttps://www.blogger.com/profile/10816744102549440439noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-71610893735735691992020-07-09T14:02:26.084-07:002020-07-09T14:02:26.084-07:00Great example and fits my dilemma almost... I have...Great example and fits my dilemma almost... I have multiple 'categories' in each group, so I need a clustered? bar chart with percentages and counts per section of each group (if that makes sense). The immediate problem was getting the axis on the bottom (solved that and was clicking so fast I can't remember how), however need it to read percentages rather than count. Would you be able to help on that? Many thanks again for this solution!LarryLhttps://www.blogger.com/profile/17266087719466061143noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-74732758972833745722019-10-13T23:31:30.192-07:002019-10-13T23:31:30.192-07:00Thank you so much, this is helpful. But can we app...Thank you so much, this is helpful. But can we apply this same to multiple columns in same chart.<br /><br />for example, as you are showing different cities in individual bars. I have to show multiple countries and their respective cities.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-7780726860959751512019-04-20T10:45:16.196-07:002019-04-20T10:45:16.196-07:00This is brilliant, thank you so much, I really app...This is brilliant, thank you so much, I really appreciate it. Warm greetings from Indonesia.Ocean Flyerhttps://www.blogger.com/profile/04123321625273796414noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-66520516213416226612018-11-14T23:49:40.173-08:002018-11-14T23:49:40.173-08:00Thanks! Great solution. Had to present data in Boa...Thanks! Great solution. Had to present data in Board meeting, with limited space available in PPT, so couldn't go with 2 charts. Your solution helped me make it within 1. Prashanthttps://www.blogger.com/profile/17502404284594505363noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-90063836045620684312016-06-11T10:32:50.581-07:002016-06-11T10:32:50.581-07:00No. The multiplication factor would remain same as...No. The multiplication factor would remain same as it applies on values rather than percentages. The idea of applying multiplicative factor is to create some space above the bar for labels. Download the workbook and try it once. Do let me know incase you face any issue(s).Thanks!Deepanshu Bhallahttps://www.blogger.com/profile/09802839558125192674noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-72206647839744863632016-06-11T04:57:53.874-07:002016-06-11T04:57:53.874-07:00Thats a brilliant solution. I have faced this issu...Thats a brilliant solution. I have faced this issue a number of times and have had to create 2 charts showing counts and percentages. just one thing though, the multiplication factor (1.15 in this case) might have to be changed as per the data distribution otherwise the labels may appear too high or too lowMadhup Modinoreply@blogger.com