How To Create A Clustered Stacked Column Chart In Excel

Поделиться
HTML-код
  • Опубликовано: 27 апр 2020
  • 📗 Download Spreadsheet: »» cutt.ly/up4excel015
    You can produce a bespoke clustered stacked column chart in Excel with this video. This is not a default Excel chart in so you need to use some hacks to get this done....I'll show you how.
    👨‍🏫 On-Screen Tutor Version: »» • How To Create A Cluste...
    With this video and workbook download you will learn how to create a clustered stacked column chart in excel. In order to make a chart with multiple stacked columns in excel you need to make use of a secondary access, which then allows you to combine stacked and clustered columns in excel charts. When you know how to make advanced bar charts in excel, like this clustered stacked column chart, you can create impress visual presentations of your data. Learn how to combine stacked and clustered columns in excel charts with Up4Excel by downloading the video workbook and watching this video.
    The key to this technique is that we're going to produce 2 clustered column charts and then we're going to overlay them on top of each other using a dual axis chart method. Then we're going to adjust them to make sure that the axes are in line and that everything falls into place.
    In the next video I'm going to be showing you how to make charts completely dynamic. Additional data will be automatically coming in to these charts when new figures come in as the chart will automatically expand to accommodate them. It will also even highlight areas where you have the maximum or minimum figures within those charts. It's going to be a great video so make sure you subscribe and hit the bell icon so you get notified when that video’s out, if it's not already.
    ======================================================================================
    #Up4Excel
    #Up4ExcelAdvanced
    #Up4ExcelCharts
    Here at Up4Excel we’re on a mission to help YOU:
    » Get your Excel skills UP and your task time DOWN
    » Focus on shortcuts and fast impressive results
    » Improve your productivity and free up your time
    Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training.
    We release multiple videos each week, packed full of ways to save time and impress those around you.
    💎 Don't miss out and fall behind.....
    🅾 SUBSCRIBE NOW 🅾
    ======================================================================================
    📗 Download Workbook: »» cutt.ly/up4excel015
    💥 Shortcuts Cheat Sheet: »» www.up4excel.co.uk/shortcuts
    📘 Dynamic Chart Template: »» cutt.ly/up4excel016
    🎁 Your small gift will help me make better videos for you and others.
    Thank You: www.paypal.me/Up4Excel?locale...
    ======================================================================================

Комментарии • 14

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

    👉 Up4Excel Downloads Library: »» ml.up4excel.com/library
    ✅ FREE Access to ALL Up4Excel Files. Includes Excel Templates, Training Workbooks, Example Data, Cheat Sheets and more. New Content Added Weekly!

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

    Thanks John. More charting magic! Thumbs up!!

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

      You bet Wayne, there's almost infinite magic that can be done with charts 👍

  • @Up4Excel
    @Up4Excel  4 года назад +1

    ✅ Learn the Excel hack for a brand new custom chart type with this video!! 📕 Download The Workbook Here: »» cutt.ly/up4excel015 ...no signup required 👍

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

    This helped me today. Thanks.

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

      Glad to hear it!

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

    Thank you so much!

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

      You're welcome! Glad it helped you Chai

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

    Its working..thanks

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

    Nice one! I really appreciate your work!. My only problem with this is that is will not give you an accurate representation. The length of the bar on top shows just the difference between the 2 and not a full-length stacked bar.

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

      Hi Liviu, thanks for your comment. I probably didn't make it clear in the video but the chart values calculation adds both values together so it does show the correct total. The bar on the top represents the whole of the second value. Have a look at the free template here cutt.ly/up4excel015. If you still think it's incorrect I'd like to hear back so I can amend for other viewers.

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

    When I tried to change the max to line chart, excel won't allow me

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

      Make sure you are definitely clicked on just that line. You can always go into the chart type options and select combo - under there you will see all the series listed and can change the chart types individually.