Excel Dynamic Charts - Easily Create Dynamic Charts using FILTER & SORT functions

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ม.ค. 2025

ความคิดเห็น • 32

  • @mikepike7063
    @mikepike7063 3 หลายเดือนก่อน

    Well done Chris, working from home ignorance is not bliss, self taught in Excel I am so blissful.
    This is exactly what I needed saving me so many headaches with VBA macros and multiple combo boxes to simulate your filter and unique examples.
    The dynamic lists are so much better in every respect to my scheme. The hidden logic is gone and it will be easier for users to see how the various charts are formed. Maintaining the sheets with my poor memory is also going to be quicker. Thank you!

  • @Robert_512
    @Robert_512 ปีที่แล้ว +1

    Good stuff Chris. The Dynamic Array formulas changed my life! No more Ctrl+Shift+Enter!

    • @ChrisMenardTraining
      @ChrisMenardTraining  ปีที่แล้ว

      I agree. Thanks, Robert

    • @pat5634
      @pat5634 ปีที่แล้ว

      Hi Chris, how can we link up. I have a question for you?

  • @Faizuddin6677
    @Faizuddin6677 4 วันที่ผ่านมา

    sir thank u so much for this amazing tutorial

  • @ClaudioCP
    @ClaudioCP ปีที่แล้ว +1

    Great overview about some key dynamic array functions. Very cool and useful examples. Thanks Chris!

  • @BabakAfsharipour
    @BabakAfsharipour 11 หลายเดือนก่อน

    You are a fantastic teacher! Thank you very much. Very useful and informative. Thank you
    Chris!

  • @rudisteenhuis
    @rudisteenhuis ปีที่แล้ว +2

    Hi Chris. TX for your great vids.
    An improvement you could make to the validation list is to place the following into the source box of the list validation: =$K$2#
    The above will always extract the whole list coming from the SORT(UNIQUE(...)) formula. If you place a hard-coded range in there, as you did when highlighting with your mouse, the list gets truncated if it grows longer.
    Keep up the great vids.
    Cheers 👍

  • @aal2002
    @aal2002 6 หลายเดือนก่อน

    Wow! This was GREAT! Thank you!

  • @AdityaKarjagi
    @AdityaKarjagi ปีที่แล้ว

    Thank you for this training material. Can you show how to add "All" option in filter?

  • @RJM-p7r
    @RJM-p7r หลายเดือนก่อน

    Is there a way to filter in two columns simultaneously to rebuild a combo chart. I have budget variables for effective date (mo/yr), confidence (0% to 100%), revenue and no of lives

  • @ellizercabahug7278
    @ellizercabahug7278 19 วันที่ผ่านมา

    Chris, I noticed when I tried to replicate the formula that if the reference cell is blank, the filter function indicates a 0. How do I make sure it remains blank?

  • @NashvilleFanatic
    @NashvilleFanatic ปีที่แล้ว +2

    Help! This isn't working for me - the chart's range is staying static based on the dynamic formula spill range when I create the chart. Any idea what I'm doing wrong? Thank you!!!

    • @maangeljose
      @maangeljose 9 หลายเดือนก่อน

      Same issue here :(

  • @markpodesta4605
    @markpodesta4605 ปีที่แล้ว +1

    Thank you Chris. So no more named ranges needed to create dynamic charts?

  • @hollyfrench7309
    @hollyfrench7309 ปีที่แล้ว +1

    Hi Chris, these dynamic functions are new to me but I just have to ask a logical question...isn't this creating the same thing as a pivot table and a pivot chart would do or is there something I'm missing in the use of these dynamic functions? Love your videos! You keep me learning!

    • @ChrisMenardTraining
      @ChrisMenardTraining  ปีที่แล้ว +1

      Hello, Holly! One difference with the dynamic function is the initial range can be sorted, and the chart stays the same since it is based on a dynamic function. With a Pivotable and PivotChart, you change one, and the other changes.

  • @frankclaeys1145
    @frankclaeys1145 7 หลายเดือนก่อน

    Hi Chris, why doesn't my chart change but my filter data does. I can see the data (made with filter function) but the graph deosn't?

  • @mchllwoods
    @mchllwoods ปีที่แล้ว +2

    U don't need to highlight the whole dynamic list in data validation. Just highlight the first cell then put # after it. It will highlight the whole list on it's own. Also, u don't need a 1 in sort function. It's in ascending order by default.

    • @ChrisMenardTraining
      @ChrisMenardTraining  ปีที่แล้ว +1

      Excellent points. Thanks, Michelle.

    • @colinhuntley9729
      @colinhuntley9729 ปีที่แล้ว

      when u know so much, make better videos yourself...

    • @mchllwoods
      @mchllwoods ปีที่แล้ว

      @@colinhuntley9729 maybe I would if twitch didn't take up my gaming/crafting time.

  • @jojothegigolo6259
    @jojothegigolo6259 9 หลายเดือนก่อน

    Can you make a trend from this function ?

  • @daninega582
    @daninega582 ปีที่แล้ว +1

    Hello Chris, is there a new method to open password protected word to open ?????

    • @ChrisMenardTraining
      @ChrisMenardTraining  ปีที่แล้ว

      No method that I know of to open a file that is password protected. I have seen third parties advertise they can, but I haven't tried any of them.

  • @daninega582
    @daninega582 ปีที่แล้ว

    Chris please can you help me to unlock password protected word document or any suggestions??? Thanks

  • @DarylHawkins-zh3ww
    @DarylHawkins-zh3ww 9 หลายเดือนก่อน

    How do you the same thing but ignoring and not creating a column for no values?

  • @ennykraft
    @ennykraft หลายเดือนก่อน

    Excel 2029 doesn't do dynamic arrays and 2021 has these function but can't create charts with dynamic arrays. You either need 365 oder 2024.