Тэги:
#XelplusVis #Advanced_Excel_Tricks #Advanced_Excel_Tutorials #Advanced_Excel_Online_Course #Best_Practices_for_charts_in_Excel #Microsoft_Excel_Tutorials #Excel_chart_tricks #Advanced_Excel_charts #Excel_for_business_analysts #excel_graphs #Leila_Gharani #stacked_column_chart #stacked_percentage_chart_excel #stacked_bar_chart_percentages #stacked_column_chart_show_percentages #add_total_values_to_stacked_chart #excel_add_percentage_to_bar_chart #excel_2010 #excel_2016 #2013Комментарии:
The best!
ОтветитьGreat ! Please, do you know how to do it in PowerBI ?
ОтветитьThanks Leila, this video was very usefully to my analysis. Regards.
ОтветитьSo helpful, thank you <3
Ответить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
Ответить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
ОтветитьHi Leila, thank you for the training. Is there a way to do this with a Pivot table as source?
ОтветитьRather too fast at times-please slow down
ОтветитьThank you very much. It's very helpful.
ОтветитьLeila. Great video. Is it possible to create a stacked actual versus target?
ОтветитьCan we see percentage on bars and a table in below with the numbers?
ОтветитьTake my bow
ОтветитьWhat a delicious voice!! 😍
ОтветитьGreat. it was very help ful
ОтветитьThank you so much !
Ответить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.
ОтветитьThanks a lot Leila 🙏
ОтветитьThank you so much this saved me!
ОтветитьHow to put a percentage range in a 100% stacked area chart?
Ответить% ^ thanks!!! :D
ОтветитьGreat content!
ОтветитьPercentages in Stacked Charts with Total Values on Top? Exactly what I need. Thank you so so much, Leila.
ОтветитьLeila, love your vids, thank you so much! Question, if the data has several items with very small percentages (<6%) and one item that is say >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 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?
ОтветитьSaved me tons of time! Tks, Leila!
Ответитьthanks
ОтветитьThanks for this video, just i want undersand how to visualize the pourcentage values in X axis, please?
Ответитьthanks. u always give simple solution
ОтветитьWow this is really helpful for me, thank you, solved my problem
Ответить@Leila
Thanks for this video,
saved me tons of time!!!
keep up great work
Thank you so much!
ОтветитьLike the persian accent, too :)
Ответитьthank you so much. very helpful.
ОтветитьExcellent work as always Leila - helped me get out of a bind!
Ответить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 👍
Ответить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.
ОтветитьCan we do the same with the pivot chart
Ответить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.
ОтветитьHow can I represent percentage in slicer function
ОтветитьThank you for this tutorial ❤️
Ответить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!
Ответитьawesome job
ОтветитьHow do I add totals to a horizontal stacked bar chart?
ОтветитьWhy fucking 12 minutes
ОтветитьVery helpful video, thanks a ton, whats the steps if I want to show the number first and percentage next?
ОтветитьLoved it!!
Ответить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.
Ответить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.
Ответить