Grab the file I used in the video from here 👉 pages.xelplus.com/percentages-stacked-charts
@nataliamunoz3089
Жыл бұрын
Hi Leila, thank you for the training. Is there a way to do this with a Pivot table as source?
@buffon114
Жыл бұрын
The best!
@automationguide3498
7 жыл бұрын
Thank You !! It's too difficult task in 2007.
@LeilaGharani
7 жыл бұрын
You're welcome Why? is it because of cell referencing? it's just a one time task though when the chart is setup for the first time and it will dynamically update when the values change...
@automationguide3498
7 жыл бұрын
If it's daily report, it's worth to take that one-time effort. However, In case of Adhoc reports , There might be some situations where I have to create and send reports as soon as possible. I might say it's cumbersome task rather than difficult.
@LeilaGharani
7 жыл бұрын
Agree :)
@Damien1_1
10 ай бұрын
I have a diff query. Can you help, please? I need to show a) 50% only patients achieved a response with treatment. 70% of this 50% patients achieved this response twice b) 32% patients achieved a response with placebo. 60% of this 32% patients achieved this response twice. So I need a 50% bar (not 100%) while showing 70% of that bar colored. I need second bar of 32% with 60% colored inside.
@eleanormarsh6261
Жыл бұрын
Thank you for this video! Your videos are always the first I look at for Excel tips, as I have found them to be clear and useful for many years. This has just helped me present some charts much more clearly for my MSc - much appreciated :)
@phungquyen3511
3 жыл бұрын
Percentages in Stacked Charts with Total Values on Top? Exactly what I need. Thank you so so much, Leila.
@michellecruz7296
Жыл бұрын
what if i have 5 stacks and i want to show the total data label. however, one stack is too big and the other four are very small. it does not allow space to be able to add those labels
@FearlessSanathani
5 жыл бұрын
Very helpful video, thanks a ton, whats the steps if I want to show the number first and percentage next?
@sergiomaia3029
2 жыл бұрын
I'm sorry, but this is not what the issue is: I don't want to create percentages as labels, but simply show percentages from the values in the chart. For instance, The label shows the value and below it the percentage. That's the real questions.
@1973youness
Жыл бұрын
Great ! Please, do you know how to do it in PowerBI ?
@daryoushjoobbani3125
2 жыл бұрын
Hi Leila. i have a question regarding the chart command. I am trying to execute a search splunk command that shows both the count and percentage of the count in one chart command: so here is an example of splunk command that currently only shows the count and the total count: source="xyz" http_status_code | chart count by path_template, http_status_code | addtotals col=t This command shows each count of the http_status_code (y axis) and the path_template (x axis) and showing the total of the counts of all the http_status_code. Now i need to add the percentage (count/total) of each count when i know the number of counts. e.g. 40 (5%) or something like that. How would i do that using chart? Thanks!
@breedbabe2007
3 жыл бұрын
you mention a previous video in here and I think that is the one I am looking for, I remember using it last year when I was working on some reports but can't seem to find it, how would I find that?
@Oppenheimer1968
Жыл бұрын
Rather too fast at times-please slow down
@keshubmathur6972
5 жыл бұрын
I am running Excel 2016 on Mac and on selecting the stacked column chart, total for me comes as a category on the horizontal axis instead of it being stacked on top like it is coming for you. How do I change it to the way it is coming up for you? Thanks!
@47koukou
3 жыл бұрын
Thanks for this video, just i want undersand how to visualize the pourcentage values in X axis, please?
@excelisfun
7 жыл бұрын
Thanks for the % fun : )
@LeilaGharani
7 жыл бұрын
you're 100% welcome :)
@josezeta7149
Жыл бұрын
Thanks Leila, this video was very usefully to my analysis. Regards.
@6torthor
5 жыл бұрын
Why fucking 12 minutes
@tmngoc29121990
6 ай бұрын
Thanks for your tutorial. Could we align the total volume ?
@ankitrawat2824
2 жыл бұрын
Thanks a lot Leila 🙏
@shri_420
2 жыл бұрын
Can we see percentage on bars and a table in below with the numbers?
@rachelessel678
2 ай бұрын
cant even begin to express my gratitude - thank you!
@mohammedal-sabbagh8463
Жыл бұрын
Thank you very much. It's very helpful.
@Veasnn_M.
3 жыл бұрын
How to put a percentage range in a 100% stacked area chart?
@TheGhurabah
7 ай бұрын
Doesn’t visually look nice
@donaldmavunduse3493
Жыл бұрын
Leila. Great video. Is it possible to create a stacked actual versus target?
@icesummer1725
4 жыл бұрын
Thank you but can please also show how to reverse the order of the numbers say i want the number value first followed by the percentage (%), example : 1,600 (74%) . Thank you.
@kzmytube
4 жыл бұрын
@Leila Thanks for this video, saved me tons of time!!! keep up great work
@willgould4417
6 ай бұрын
Thank you, your explanations are very helpful
@jalcantar6857
3 жыл бұрын
Leila, love your vids, thank you so much! Question, if the data has several items with very small percentages (94%, how would you recommend displaying the data showing the smaller items (~8 items) and still being able to see the percentage for each smaller item? TY so much!
@VuthyVa
3 жыл бұрын
thanks. u always give simple solution
@rickys9388
3 жыл бұрын
% ^ thanks!!! :D
@jayaarun
4 жыл бұрын
Thank you so much for sharing this video. I was kind of struggling to work on the multiple values in the chart. Now this video gonna help me to make my presentation to a better version 🤞 Thanks again. You are a great teacher 👍
@busisiwentuli8362
2 жыл бұрын
Xxx. Bxbb honeymoon ln aaaaaa take hshsjsjzkzkssjsjshhdjdjjfhfhfhfdhhxhxhxhxhxhxh Dr hdhdjhddhhdhfhchchxxhchchhcchhxhchxhchchchhchchchcbhhhhdhdjdjjdjddjdjfjfjfjfjfjfjfjfjffjjfjfhchccf vvvggfxx CV dhdgfg go hvfhfjxjdjdjfhxhxhxhxjxjxjxjjdos
@jehooncho6976
2 жыл бұрын
Thank you so much this saved me!
@upulranaweera3597
5 жыл бұрын
Your video are excellent. I learn a lot. Could you tell me how to show the percentage of a data value in a column chart, not a stackbar. Thank you in advance.
@gandhiamanullah388
4 жыл бұрын
thank you so much. very helpful.
@Tony_Montana659
2 жыл бұрын
Great. it was very help ful
@aBean2GO
4 жыл бұрын
Wow this is really helpful for me, thank you, solved my problem
@know1squarter307
Жыл бұрын
Thank you
@akiradon-kaizen7887
2 жыл бұрын
What a delicious voice!! 😍
@ЖанботаЖакупова
Жыл бұрын
So helpful, thank you
@omaralkassem4630
5 жыл бұрын
How can I represent percentage in slicer function
@marekkusior1266
6 ай бұрын
🤜🏼🤛🏼😎
@margaretforde1721
6 ай бұрын
V good
@lakesign4177
4 жыл бұрын
Like the persian accent, too :)
@tranhoangviet5574
17 күн бұрын
thank you very much, I can do that now.
@BS2Dos
7 жыл бұрын
Hey Leila, I'm trying to add percentage differences like you've shown in the video. However, I'm using a column chart and not a stacked chart and which has two series of data . I've tried adding a new series and then removing the colour and the column line, so the new series sits behind the column I want to show, but for some reason the new data series is not hiding behind the first series. No matter how much overlap I apply, the new series sits between the two columns. Obviously, I want to use the third series to add the % data labels. Do you have any tutorials which can help me resolve this issue? Hope you can help. Thanks.
@LeilaGharani
7 жыл бұрын
Hi Neil - change the chart type of the last series (the one with percentages) to a line series. Make the line then invisible and activate the data labels - you can then point to the percentages (if you have excel 2013 & above) or use a formula to reference the percentages... hope that helps...
@BS2Dos
7 жыл бұрын
It does. Thanks, Leila. As an alternative, I saw another youtube video which said you can create a filler column of data with say, +10% of the source data value and then create a stacked chart. Then hide the 10% section and add the labels from there. Anyhow, I'll try your suggestion. Thanks again.
@arthoruslegends3888
3 жыл бұрын
Saved me tons of time! Tks, Leila!
@Sal_A
7 жыл бұрын
Great video. From what I hear, stacked columns and pie charts should be avoided as best as possible. A bar chart in descending order by continent for each year would paint a better picture IMHO.
@LeilaGharani
7 жыл бұрын
Agree. Sorted bar chart is always a good method - in case anyone looks for that video, here is the link: kzitem.info/news/bejne/2YWV0nd_ep6fiWU - although I still find stacked columns much easier to read than a pie chart - because the shapes of the stacks are easier to compare than the slices in the pie....
@CarshaltonAdvisory
4 жыл бұрын
Excellent work as always Leila - helped me get out of a bind!
@LeilaGharani
4 жыл бұрын
Happy to help!
@kib4057
2 жыл бұрын
Thank you so much !
@AweshBhornya-ExcelforNewbies
6 жыл бұрын
The last part of the video where you say use the Y Axis to deduce the value is a little too confusing at times so why don’t we create a VBA code and give the control to the user to se the values or values as percentages through the code. Just a thought.
@LeilaGharani
6 жыл бұрын
Hi Awesh - That's a good point. Yes - some people use VBA for this.
@AweshBhornya-ExcelforNewbies
6 жыл бұрын
Leila Gharani let me try it out and posts link to the video
@storyover2311
7 жыл бұрын
Dear Leila,, Thank you for your efforts and I want ask you If I am zero at excel? What's the best advice you can tell me if I want go pro ? شكرا ،، Thanks,
@LeilaGharani
7 жыл бұрын
Start with a basic Excel course - it's important to know the fundamentals before jumping in to advanced. Aim to do the Microsoft certification - basic and Excel expert - that makes you learn different aspects of the program. Once you feel comfortable in Excel, go to forums and try to answer people's questions. Most of what I learnt was trying to answer other people's questions..... hope that helps.
@loomdoby
4 жыл бұрын
Can we do the same with the pivot chart
@shri_420
2 жыл бұрын
Take my bow
4 жыл бұрын
Thank you so much!
@gianluca9109
3 жыл бұрын
Great content!
@andrewdutch4843
5 жыл бұрын
How do I add totals to a horizontal stacked bar chart?
@LeilaGharani
5 жыл бұрын
You can use a scatter plot for the labels. I'll make a video on this.
@hosseinhosseinpoor4845
3 жыл бұрын
thanks
@mohamedmami2480
7 жыл бұрын
Thanks a lot Leila for this video , it's much appreciated.
@LeilaGharani
7 жыл бұрын
You're welcome Mohamed
@SpiroPT
7 жыл бұрын
Brilliant, Thanks for sharing. Finally found a way to merge 2 separate graphs in to a single one.
@LeilaGharani
7 жыл бұрын
You're welcome Spiro! Glad to hear you're applying it to own reports :)
@Packguitar182
5 жыл бұрын
awesome job
@phamhoangtien
7 жыл бұрын
Thank you so much for this video! I concern that how can we put the percent into the second line under the value?
@LeilaGharani
7 жыл бұрын
You're welcome Pham. If I understand your question right, to get it the other way round, you just how to put the percentages below the values in the data preparation table.
@phamhoangtien
7 жыл бұрын
Leila Gharani Yeah, i got it. This will be done with the third table combining % and value by formula. With the 1st way, when we choose data label and show "value from cell" (tick to Value button also), can we put the % after the Value?
@williamnjau3987
4 жыл бұрын
@@phamhoangtien Did you ever figure this out, I am struggling with the same thing today
@phamhoangtien
4 жыл бұрын
@@williamnjau3987 send your file to phamhoangtien.381@gmail.com
Пікірлер: 93