@@AnthonySmoak I am going to use this to track our order count by vendor and then within the serialized stacked data bar I will list what percentage is 30, 60, 90, etc.
Great vid. How do you change the height of the stacks (diff colors) containing the data series values? Sometimes for very small values excel makes the height of the cell too small to fit the data label font.
Adding labels to a horizontal stacked chart is exactly what I was trying to do! Thank you for explaining this so clearly.
Thank you, glad to help!
Adding labels to a horizontal stacked chart is exactly what I was trying to do (@6:35). Thanks for the nifty tips as it works like a charm.
Glad to hear it!
Anthony, from the bottom of my heart, thank you 😭😭
You're very welcome; sounds like this video really helped! 📊
This man is a geniiiiiiius! Thanks for sharing this great tutorial
This comment made my day, thank you!
@@AnthonySmoak you're welcome! Something about getting the formula or thing in Excel to work right ... simple pleasures
Thank you for solving my totals problem!!!
Thanks for commenting!
great video, did this on power point stacked bar and it worked.
Actual lesson go from 04:00 to 6:22. Thank you!
A perfect solution to my requirement. Thank you for the video.
Glad to hear it, thanks!
Thank you so much, this will aid my business project so much.
Thank you for sharing!
@@AnthonySmoak I am going to use this to track our order count by vendor and then within the serialized stacked data bar I will list what percentage is 30, 60, 90, etc.
Fantastic stacked bar total hack, thank you! Crazy Microsoft doesn't have a built-in feature for it...
Thanks and I agree. Excel definitely makes it harder than it needs to be.
Exactly what I was looking for ❤ thanks bro 😎 👊
Thanks for the comment!
Hooray! This solved my problem. Thanks so much
Glad to hear it! Thanks for commenting.
Lifesaver, thank you!!!
Really really helpful! Thank you Anthony
I'm glad this Excel tip worked out for you!
OMG THIS IS EXACTLY WHAT I NEEDED!!! - THANKS!!!!!
Glad it worked out for you!
Great tip. Great explanation. Thanks!
Great video. Very helpful
Thank you! Glad you found it useful
Great Vid, Thanks a lot man
Glad my video helped, thanks for the comment!
outstanding
Thank you!
Great vid. How do you change the height of the stacks (diff colors) containing the data series values? Sometimes for very small values excel makes the height of the cell too small to fit the data label font.
thank uuuuuuu
Youuuuur welcome!
Can we achieve this using tableau? If yes, could you please show it how to do this using tableau?
Certainly ua-cam.com/video/CylyFY0UIj0/v-deo.html
how to create a trellis chart in tableau Sir
Power BI is a better tool for creating Trellis charts in the Microsoft stack.
is there a way to add total value for 3d stacked column
I've never tried, but 3D charts in general are not reccomend for data visualization as they are harder to interpret.
@@AnthonySmoak tell this to my boss?
Gladly, I have nothing to lose :) In all seriousness, although 3D is not best practice, there are always reasons to break the rules.