Add Total Values for Stacked Charts in Excel: Column & Bar Charts
This is the only video you need to learn how to add Add Totals to Stacked Bar Charts in Excel. I will show you how to achieve this task for BOTH types of Excel stacked charts (Stacked Column Chart and Stacked Bar Chart).
★☆★ Join this channel to get access to perks: ★☆★
/ @anthonysmoak
★☆★ FOLLOW ME BELOW: ★☆★
bit.ly/m/anthonysmoak
☕☕ If my channel has helped you, consider buying me a coffee! Thanks & Cheers! ☕☕ www.buymeacoffee.com/anthonys...
★☆★ Support this Channel: ★☆★ Merch
► shop.spreadshirt.com/AnthonySmoak
#Excel #analytics #data #dataanalyst #education #onlinelearning #ExcelTutorial #StackedBarTotals #SaveTimeInExcel #ExcelHacks #DataAnalysis
Пікірлер: 47
Actual lesson go from 04:00 to 6:22. Thank you!
Adding labels to a horizontal stacked chart is exactly what I was trying to do! Thank you for explaining this so clearly.
@AnthonySmoak
Жыл бұрын
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.
@AnthonySmoak
8 ай бұрын
Glad to hear it!
Anthony, from the bottom of my heart, thank you 😭😭
@AnthonySmoak
4 ай бұрын
You're very welcome; sounds like this video really helped! 📊
great video, did this on power point stacked bar and it worked.
Lifesaver, thank you!!!
Great tip. Great explanation. Thanks!
Really really helpful! Thank you Anthony
@AnthonySmoak
3 жыл бұрын
I'm glad this Excel tip worked out for you!
Thank you for solving my totals problem!!!
@AnthonySmoak
Жыл бұрын
Thanks for commenting!
Hooray! This solved my problem. Thanks so much
@AnthonySmoak
3 жыл бұрын
Glad to hear it! Thanks for commenting.
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.
This man is a geniiiiiiius! Thanks for sharing this great tutorial
@AnthonySmoak
Жыл бұрын
This comment made my day, thank you!
@freddiegibbs101
Жыл бұрын
@@AnthonySmoak you're welcome! Something about getting the formula or thing in Excel to work right ... simple pleasures
A perfect solution to my requirement. Thank you for the video.
@AnthonySmoak
2 жыл бұрын
Glad to hear it, thanks!
Exactly what I was looking for ❤ thanks bro 😎 👊
@AnthonySmoak
2 ай бұрын
Thanks for the comment!
OMG THIS IS EXACTLY WHAT I NEEDED!!! - THANKS!!!!!
@AnthonySmoak
2 жыл бұрын
Glad it worked out for you!
Great Vid, Thanks a lot man
@AnthonySmoak
2 жыл бұрын
Glad my video helped, thanks for the comment!
Fantastic stacked bar total hack, thank you! Crazy Microsoft doesn't have a built-in feature for it...
@AnthonySmoak
2 жыл бұрын
Thanks and I agree. Excel definitely makes it harder than it needs to be.
Great video. Very helpful
@AnthonySmoak
5 ай бұрын
Thank you! Glad you found it useful
Thank you so much, this will aid my business project so much.
@AnthonySmoak
2 жыл бұрын
Thank you for sharing!
@williamdaniels9728
2 жыл бұрын
@@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.
outstanding
@AnthonySmoak
2 жыл бұрын
Thank you!
thank uuuuuuu
@AnthonySmoak
2 жыл бұрын
Youuuuur welcome!
Can we achieve this using tableau? If yes, could you please show it how to do this using tableau?
@AnthonySmoak
3 жыл бұрын
Certainly kzread.info/dash/bejne/da2g26iSYLivmpM.html
how to create a trellis chart in tableau Sir
@AnthonySmoak
3 жыл бұрын
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
@AnthonySmoak
Жыл бұрын
I've never tried, but 3D charts in general are not reccomend for data visualization as they are harder to interpret.
@meliheser01
Жыл бұрын
@@AnthonySmoak tell this to my boss?
@AnthonySmoak
Жыл бұрын
Gladly, I have nothing to lose :) In all seriousness, although 3D is not best practice, there are always reasons to break the rules.