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 :)
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 👍
Xxx. Bxbb honeymoon ln aaaaaa take hshsjsjzkzkssjsjshhdjdjjfhfhfhfdhhxhxhxhxhxhxh Dr hdhdjhddhhdhfhchchxxhchchhcchhxhchxhchchchhchchchcbhhhhdhdjdjjdjddjdjfjfjfjfjfjfjfjfjffjjfjfhchccf vvvggfxx CV dhdgfg go hvfhfjxjdjdjfhxhxhxhxjxjxjxjjdos
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.
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!
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...
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.
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?
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,
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.
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.
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.
Agree. Sorted bar chart is always a good method - in case anyone looks for that video, here is the link: ruclips.net/video/xO_lCIAlnV0/видео.html - 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....
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!
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.
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?
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!
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
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.
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.
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.
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...
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.
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.
Grab the file I used in the video from here 👉 pages.xelplus.com/percentages-stacked-charts
cant even begin to express my gratitude - thank you!
Percentages in Stacked Charts with Total Values on Top? Exactly what I need. Thank you so so much, Leila.
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 :)
Thanks Leila, this video was very usefully to my analysis. Regards.
Thank you, your explanations are very helpful
Thanks a lot Leila 🙏
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 👍
Xxx. Bxbb honeymoon ln aaaaaa take hshsjsjzkzkssjsjshhdjdjjfhfhfhfdhhxhxhxhxhxhxh Dr hdhdjhddhhdhfhchchxxhchchhcchhxhchxhchchchhchchchcbhhhhdhdjdjjdjddjdjfjfjfjfjfjfjfjfjffjjfjfhchccf vvvggfxx CV dhdgfg go hvfhfjxjdjdjfhxhxhxhxjxjxjxjjdos
Thank you very much. It's very helpful.
Thank you
thanks. u always give simple solution
Saved me tons of time! Tks, Leila!
Excellent work as always Leila - helped me get out of a bind!
Happy to help!
Thank you so much !
Take my bow
Great content!
Thank you so much this saved me!
So helpful, thank you
Very helpful video, thanks a ton, whats the steps if I want to show the number first and percentage next?
Thanks for your tutorial. Could we align the total volume ?
Great. it was very help ful
Brilliant, Thanks for sharing. Finally found a way to merge 2 separate graphs in to a single one.
You're welcome Spiro! Glad to hear you're applying it to own reports :)
thank you so much. very helpful.
What a delicious voice!! 😍
The best!
thanks
Wow this is really helpful for me, thank you, solved my problem
Thanks a lot Leila for this video , it's much appreciated.
You're welcome Mohamed
First-rate presentation.
Thanks.
You're welcome.
awesome job
@Leila
Thanks for this video,
saved me tons of time!!!
keep up great work
Thank you for this tutorial ❤️
You're very welcome Oliver. Glad you like it.
Great ! Please, do you know how to do it in PowerBI ?
Thanks for the % fun : )
you're 100% welcome :)
Thanks for this video, just i want undersand how to visualize the pourcentage values in X axis, please?
Loved it!!
YIAA😂
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.
Hi Leila, thank you for the training. Is there a way to do this with a Pivot table as source?
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!
Leila. Great video. Is it possible to create a stacked actual versus target?
Thanks Madam
You're welcome swetav.
Thank You !!
It's too difficult task in 2007.
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...
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.
Agree :)
Wonderful! Thanks Leila :-)
You're welcome Alex :)
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?
V good
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,
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.
Can we see percentage on bars and a table in below with the numbers?
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.
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.
Agree. Sorted bar chart is always a good method - in case anyone looks for that video, here is the link: ruclips.net/video/xO_lCIAlnV0/видео.html - 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....
Like the persian accent, too :)
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!
Thank you so much for this video! I concern that how can we put the percent into the second line under the value?
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.
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?
@@phamhoangtien Did you ever figure this out, I am struggling with the same thing today
@@williamnjau3987 send your file to phamhoangtien.381@gmail.com
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!
How can I represent percentage in slicer function
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
Can we do the same with the pivot chart
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.
Hi Awesh - That's a good point. Yes - some people use VBA for this.
Leila Gharani let me try it out and posts link to the video
How to put a percentage range in a 100% stacked area chart?
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.
% ^ thanks!!! :D
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.
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...
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.
How do I add totals to a horizontal stacked bar chart?
You can use a scatter plot for the labels. I'll make a video on this.
🤜🏼🤛🏼😎
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.
Rather too fast at times-please slow down
Doesn’t visually look nice
Why fucking 12 minutes
Thank you so much!