Add Total Values for Stacked Charts in Excel: Column & Bar Charts

Поделиться
HTML-код
  • Опубликовано: 6 июл 2024
  • 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).
    ★☆★ 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

  • @dragonstar1031
    @dragonstar1031 Год назад +4

    Adding labels to a horizontal stacked chart is exactly what I was trying to do! Thank you for explaining this so clearly.

  • @debanjandhar3095
    @debanjandhar3095 3 месяца назад +1

    Anthony, from the bottom of my heart, thank you 😭😭

    • @AnthonySmoak
      @AnthonySmoak  3 месяца назад

      You're very welcome; sounds like this video really helped! 📊

  • @dspblacker
    @dspblacker Месяц назад +1

    Exactly what I was looking for ❤ thanks bro 😎 👊

  • @yunush
    @yunush 8 месяцев назад +1

    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.

  • @freddiegibbs101
    @freddiegibbs101 11 месяцев назад +2

    This man is a geniiiiiiius! Thanks for sharing this great tutorial

    • @AnthonySmoak
      @AnthonySmoak  11 месяцев назад +1

      This comment made my day, thank you!

    • @freddiegibbs101
      @freddiegibbs101 11 месяцев назад +1

      @@AnthonySmoak you're welcome! Something about getting the formula or thing in Excel to work right ... simple pleasures

  • @atkearns
    @atkearns 2 года назад +1

    Great tip. Great explanation. Thanks!

  • @faithfertick1040
    @faithfertick1040 11 месяцев назад +1

    Thank you for solving my totals problem!!!

  • @MrRubberducky216
    @MrRubberducky216 3 года назад +1

    Lifesaver, thank you!!!

  • @NFSDriver
    @NFSDriver Год назад +1

    great video, did this on power point stacked bar and it worked.

  • @josemwarrior
    @josemwarrior 4 месяца назад +1

    Actual lesson go from 04:00 to 6:22. Thank you!

  • @creggroad
    @creggroad 3 года назад +1

    Really really helpful! Thank you Anthony

    • @AnthonySmoak
      @AnthonySmoak  3 года назад

      I'm glad this Excel tip worked out for you!

  • @regihamp0206
    @regihamp0206 2 года назад

    OMG THIS IS EXACTLY WHAT I NEEDED!!! - THANKS!!!!!

  • @suziemoore7540
    @suziemoore7540 3 года назад +1

    Hooray! This solved my problem. Thanks so much

    • @AnthonySmoak
      @AnthonySmoak  3 года назад

      Glad to hear it! Thanks for commenting.

  • @Rj_8538
    @Rj_8538 2 года назад +1

    A perfect solution to my requirement. Thank you for the video.

  • @johnshambra8421
    @johnshambra8421 5 месяцев назад +1

    Great video. Very helpful

    • @AnthonySmoak
      @AnthonySmoak  5 месяцев назад

      Thank you! Glad you found it useful

  • @deepcoolclear
    @deepcoolclear 3 года назад +1

    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.

  • @surajmohite858
    @surajmohite858 2 года назад +1

    Great Vid, Thanks a lot man

    • @AnthonySmoak
      @AnthonySmoak  2 года назад

      Glad my video helped, thanks for the comment!

  • @williamdaniels9728
    @williamdaniels9728 2 года назад +1

    Thank you so much, this will aid my business project so much.

    • @AnthonySmoak
      @AnthonySmoak  2 года назад +1

      Thank you for sharing!

    • @williamdaniels9728
      @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.

  • @2229lionman
    @2229lionman 2 года назад +3

    Fantastic stacked bar total hack, thank you! Crazy Microsoft doesn't have a built-in feature for it...

    • @AnthonySmoak
      @AnthonySmoak  2 года назад

      Thanks and I agree. Excel definitely makes it harder than it needs to be.

  • @andrewaguirre8166
    @andrewaguirre8166 2 года назад +1

    outstanding

  • @beeble7636
    @beeble7636 2 года назад +1

    thank uuuuuuu

  • @kalyanipawar6205
    @kalyanipawar6205 3 года назад

    Can we achieve this using tableau? If yes, could you please show it how to do this using tableau?

    • @AnthonySmoak
      @AnthonySmoak  3 года назад

      Certainly ruclips.net/video/CylyFY0UIj0/видео.html

  • @shobanb1066
    @shobanb1066 3 года назад

    how to create a trellis chart in tableau Sir

    • @AnthonySmoak
      @AnthonySmoak  3 года назад

      Power BI is a better tool for creating Trellis charts in the Microsoft stack.

  • @meliheser01
    @meliheser01 Год назад

    is there a way to add total value for 3d stacked column

    • @AnthonySmoak
      @AnthonySmoak  Год назад

      I've never tried, but 3D charts in general are not reccomend for data visualization as they are harder to interpret.

    • @meliheser01
      @meliheser01 Год назад

      @@AnthonySmoak tell this to my boss?

    • @AnthonySmoak
      @AnthonySmoak  Год назад

      Gladly, I have nothing to lose :) In all seriousness, although 3D is not best practice, there are always reasons to break the rules.