Excel Dynamic Chart with Drop down List (column graph with average line)

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 ต.ค. 2024

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

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

    Grab the file I used in the video from here 👉 pages.xelplus.com/dynamic-chart-file

  • @noexpert1481
    @noexpert1481 6 ปีที่แล้ว +80

    you are by far the best excel instructor on youtube

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว +5

      Thank you very much for the kind words - there are great Excel channels on TH-cam - the fact that you think mine is good does mean a lot. Thank you for your support.

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

      Hey Leila, there are many channels on you tube for excel but the way you explains is very simple and understanding, I am learning a lot from your videos. This really help me a lot to upscale my excel skills.
      Thank you for all your efforts to make people learn excel in easier and interesting way. Keep up the Good Work. Thanks 😘

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

      @@LeilaGharani You are the best Excel instructor in TH-cam

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

    I love this lady - and her tutorials are so concise and clear.

  • @gecemetrosu9734
    @gecemetrosu9734 4 ปีที่แล้ว

    I want to thank you 1.000.000 times for your teaching method and share the workbook , I appreciate and grateful for your channel

  • @fayi85
    @fayi85 3 ปีที่แล้ว

    As usual, Leila makes it easier. No complex explanation, no jargons. Simple presentation that anyone can understand

  • @juangregory
    @juangregory 2 ปีที่แล้ว

    Leila: I've watched half a dozen of these index/match videos, and I just wasn't getting it. And I had to watch yours several times, but then the light went ON and now I've saved HOURS of work. Thank you so much.

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

    I call her the Queen of Excel. Thank you Leila🥰

  • @federicomassimo3898
    @federicomassimo3898 4 ปีที่แล้ว

    Can't believe the things that you do with Excel... It's music listening to you, with peace, breaking de world!!!

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

      Wow, thank you Federico.

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

    Wow, your vids are State of the Art. Thanks ever so much for these. Can’t believe these are available for free 🤩

  • @luisolivaresferre3600
    @luisolivaresferre3600 4 ปีที่แล้ว +8

    Best excel teacher in youtube, I will be definetely enrolling in one of your courses!

  • @michaelb1785
    @michaelb1785 4 ปีที่แล้ว

    Definitely the best excel instructor on you tube. Very professional!

  • @RaviKumar-gz9my
    @RaviKumar-gz9my 3 ปีที่แล้ว

    Excellent. It helped Again. Leila has given all the Solutions for all the Practical Issues. Thanks again.

  • @mohant664
    @mohant664 6 ปีที่แล้ว

    You are one of the best Excel tutor in the TH-cam especially teaching complex things in simple steps......Thanks a lot..

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Thank you for the kind words!

  • @ms.najneenislam9553
    @ms.najneenislam9553 6 ปีที่แล้ว +7

    You are the best instructor indeed!! cause you let us show about the most necessary practical examples which are really helpful for corporate life that makes you different fron others. God bless you :)

  • @Sman201
    @Sman201 6 หลายเดือนก่อน +1

    Worked like a charm, thank you greatly!

  • @Dhanesh87
    @Dhanesh87 2 ปีที่แล้ว

    Thank you for your helpful video lessons.

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

    So easy to follow up. Absolutely not boring. You are smart and also beautiful. Keep it up. Greetings from Azerbaijan.

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

    I like your simplicity in explaining

  • @ibraheemmshezad400
    @ibraheemmshezad400 4 ปีที่แล้ว

    wl mam ur teaching level is very god i am satisfied about ur lecture

  • @mikemmmuema5270
    @mikemmmuema5270 6 ปีที่แล้ว

    You cant understand how you help people leila but all in all you do a great job thanks for the good lessons you give us

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      Ohhh thank you Mike for your kind words & thank you for your support.

  • @inesmariz6507
    @inesmariz6507 5 ปีที่แล้ว

    this saved my statistics group project

  • @jayavelanhari197
    @jayavelanhari197 2 ปีที่แล้ว

    Dear ma'am
    Excellent information.i am one of your regular learner of your video
    Thanks

  • @davidjsaul
    @davidjsaul 3 ปีที่แล้ว +4

    Thank you so much for this. I was trying to read how to do this on various websites but getting really confused. Followed your video to the letter and it worked fine (even though I still have no clue what half the formulas mean!).

  • @s.anandanatarajan650
    @s.anandanatarajan650 3 ปีที่แล้ว

    Always your video will help to improve my skill in excel

  • @anish_k
    @anish_k 4 ปีที่แล้ว

    Thanks a lot mam, your teaching methodology is outstanding and thanks again for not including any advertisement, and you just earned yourself a satisfied student (subscriber).

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

    Thanks a lot for this video. Alleviated my frustrations quite a bit

  • @vijayppt2007
    @vijayppt2007 3 ปีที่แล้ว

    very useful for the charting.Thanks

  • @1gopalakrishnarao
    @1gopalakrishnarao 6 ปีที่แล้ว

    Every video is helping a lot to the Excel learners/users/addicts. As usual A BIG SALUTE, FROM THE BOTTOM OF MY HEART TO MY BELOVED EXCEL TEACHER, With a sincere request to start the series of VBA, A prayer to the almighty to bless her good health, as she is doing a great and noble job. MAKING THINGS EASIER with Excel tricks/tips/Graphs and what not in the days to come.

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      Thank you very much Gopala. I am thankful for your support! I will start VBA in the new year. I am already putting together the topics and will start filming once I get a few projects out of the way for this year.

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

      My Beloved Teacher, You are a great person, I appreciate your interest, zeal, enthusiasm, vigour, grit, dexterity and tenacity in publishing videos in Excel, and making things very easy. Waiting eagerly for your new videos.

  • @ThePimpLoving
    @ThePimpLoving 5 ปีที่แล้ว

    Definitely 1 of the best excel Instructors...Learned and still learning a lot from your videos...keep the good Work up.. God Bless

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Thank you for the kind words. I'm glad you find the tutorials helpful.

  • @knk1451
    @knk1451 3 ปีที่แล้ว

    Exact video I looking for me & clear all doubt in One watch only... Great

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

    Once again, goddess of excel helped me out.

  • @AdiCristea
    @AdiCristea 6 ปีที่แล้ว +4

    What I love is that after watching your videos and taking your courses for a week now, I knew straight away the answer is going to be Data Preparation and Index/Match. Thank you for making my mind work this way!

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

      This made me smile :) Thank you Adi for your comment. I'm glad to hear you enjoy the courses.

  • @lenava68
    @lenava68 3 ปีที่แล้ว

    You really explain things in a very easy manner. Cool !! Good call!. Please put more videos like this ..Thank you

  • @t3geek
    @t3geek 6 ปีที่แล้ว

    Your videos have helped me become much better at my job.....thanks!

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      You're welcome Josh! I'm very happy to hear that. Thanks for your comment.

  • @goutamtiwari2334
    @goutamtiwari2334 3 ปีที่แล้ว

    Great explanation, Thanks.

  • @sanjeevmishra106
    @sanjeevmishra106 6 ปีที่แล้ว +3

    Simplicity at its best!!!!. I really appreciate the way you explain things. Great work.. keep it the way it is...

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      Thanks a lot! Glad you like it :)

  • @jacobmnisi
    @jacobmnisi 3 ปีที่แล้ว

    Hi I really watching your videos, they are so educational

  • @aek3945
    @aek3945 6 ปีที่แล้ว

    Leila, thank you so very much for taking your time to prepare Excel videos.

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      You're very welcome. Thank you for watching, commenting & supporting.

    • @aek3945
      @aek3945 6 ปีที่แล้ว

      My pleasure...Also, do you have videos on preparing a budget? Kind regards,

  • @iwonasajdak2893
    @iwonasajdak2893 4 ปีที่แล้ว

    Thank you for all your videos. They are very helpful and you really are a great teacher

    • @LeilaGharani
      @LeilaGharani  4 ปีที่แล้ว

      Glad you like them Iwona!

  • @wenj2011
    @wenj2011 6 ปีที่แล้ว

    Great video, you use simple words and make things so clear and easy.

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      I'm very glad to hear that. Thanks for your support.

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

    Pretty awesome video! Many thanks!

  • @ghazalkz4540
    @ghazalkz4540 4 ปีที่แล้ว

    خیلی خیلی ممنون. واقعا مفید بود

  • @AshokKumarYadav-qx4jq
    @AshokKumarYadav-qx4jq 4 ปีที่แล้ว

    Very Good chart. Can be change the colour of the chart dynamically while selecting the another value from drop down list

  • @shruthit3104
    @shruthit3104 2 ปีที่แล้ว

    Thank youuuuuuuuuu. I was looking for this

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

    Really Nice I'm an excel freak and I love the way you explain

  • @szymondybowski7868
    @szymondybowski7868 5 ปีที่แล้ว

    You are doing a very good job by showing us all these tricks to make our excel skills godlike.... :) keep it up, fantastic explanations and easy to understand.

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      I will do my best :) Glad you like the tutorials.

  • @mistofstars
    @mistofstars 5 ปีที่แล้ว

    I didnt know index could be with two match formulas, so learned again something. Cool! And the chart is simply but super impressive!

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Yes, it can be really handy. Glad you like the tutorial.

  • @mpurintun
    @mpurintun 2 ปีที่แล้ว

    This was exactly what I was looking for. AND - you made it sound so easy. Can't thank you enough....

  • @subratadutta4562
    @subratadutta4562 5 ปีที่แล้ว

    Very crisp and clear

  • @PankajSharma-gi6qj
    @PankajSharma-gi6qj 4 ปีที่แล้ว

    Thanks Leila Gharani.
    very well explained!!

  • @ManjuSharmaksa123
    @ManjuSharmaksa123 5 ปีที่แล้ว

    EXCELLENT, Your are the best excel teacher. wonderful Leila, Thanks

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Thanks for the kind words!

  • @edithmona5433
    @edithmona5433 5 ปีที่แล้ว

    You help a lot in my computer course!!!!! Great video!!!

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      I'm very happy to hear that Edith :)

  • @youtugal
    @youtugal 5 ปีที่แล้ว

    Very good instruction. short and to the point!! thank you. Also you gave many tips for issues which I struggled with!

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      You're very welcome. I'm glad the tutorial is helpful.

  • @parichaybhatt46
    @parichaybhatt46 3 ปีที่แล้ว

    Great vdo, great explanation for the concept. Your way of teaching makes it easier to understand the concepts in one go. Love ur vdos. Greetings from India❤️

  • @balajithandavan6842
    @balajithandavan6842 5 ปีที่แล้ว

    Best video..., Best experiment .. good things...

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Glad you like the video.

  • @LokeshSharma-vw7ku
    @LokeshSharma-vw7ku 4 ปีที่แล้ว

    its easy and you are the best ever

  • @rslive2k
    @rslive2k 4 ปีที่แล้ว

    You're god sent.. Love from INDIA

  • @sanawarali4727
    @sanawarali4727 4 ปีที่แล้ว

    Thanks, excellent work, you got a new subscriber

    • @LeilaGharani
      @LeilaGharani  4 ปีที่แล้ว

      Great! Glad to have you here.

  • @siujiawong2607
    @siujiawong2607 2 ปีที่แล้ว

    Thank you so much! This video is very clear and useful!

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

    Thank you, I am from Mongolia.

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

    You are a genius!! Thanks

  • @davidbond70
    @davidbond70 6 ปีที่แล้ว

    Hi Leila, Your videos are really helping me to understand excel, I truly appreciate the work you have put in.

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      Thank you David for your comment & support! I'm glad you find the videos useful :)

  • @mro3un663
    @mro3un663 4 ปีที่แล้ว

    Thank you for sharing. Please do more tutorials with financial charts and graphs.

  • @ShoaibAhmed-bc3sb
    @ShoaibAhmed-bc3sb 5 ปีที่แล้ว +1

    Thank you so much. I am not good in charts and i was looking for this and finally i learned it.

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      That's great to hear. I'm glad the tutorial is helpful.

  • @ich_bin_vishal
    @ich_bin_vishal 3 ปีที่แล้ว

    I got that in one go with the help of this video, amazing, thank you so much for these quick and easy tutorials :) :)

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

    well explained, thanks!

  • @fernandopaiva8979
    @fernandopaiva8979 6 ปีที่แล้ว

    Hi Leila, I speak from Brazil, your videos are amazing! very well learn skills other cultures of the world! to continue with the work!
    very good

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      Thank you Fernando for your very nice comment. I am glad to hear you like the videos : )

  • @deepakjames52
    @deepakjames52 4 ปีที่แล้ว

    You are the art of mastering..

  • @PraveenDamarla
    @PraveenDamarla 5 ปีที่แล้ว

    good one and easy to learn. thanks for the Video

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Glad you like the tutorial.

  • @hariradhu
    @hariradhu 6 ปีที่แล้ว

    Hi Leila Gharani, I become your fan for the lovely vedios and your extrem knowledge in Excel. Hat's of to you.

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

      Thank you for your comment & support. I'm glad you like the videos you see here. I don't have extreme knowledge though.... I'm still learning everyday....

  • @ruchigupta6520
    @ruchigupta6520 5 ปีที่แล้ว

    Lovely work Leila. Thank u so much. Being a beginner trying to work around. Great help !!!

  • @aftabhussain6428
    @aftabhussain6428 4 ปีที่แล้ว

    A very informative and helpful

  • @joealexander2181
    @joealexander2181 3 ปีที่แล้ว

    Thank you Leila.

  • @CoachMattDoming
    @CoachMattDoming 2 ปีที่แล้ว

    I love you Leila, you saved my day

  • @margaritochacon840
    @margaritochacon840 3 ปีที่แล้ว

    Great explanation and easy to follow, thank you so much.

  • @COLA888
    @COLA888 4 ปีที่แล้ว

    Excellent! You are so smart! Thank you!

  • @mohdanees9253
    @mohdanees9253 4 ปีที่แล้ว

    Things look very easy in your hand

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

    Hi Leila, Very simple and well explained. I am specializing in excel after seeing your excel video. Thanks a Lot

  • @hrhussein11
    @hrhussein11 4 ปีที่แล้ว

    Really I like videos , its very helpful

  • @sunjaytube
    @sunjaytube 5 ปีที่แล้ว

    Nice explanation and presentation. Thank you so much for your guidance

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

      You're very welcome. Glad you like the video.

  • @felipemendes7408
    @felipemendes7408 6 ปีที่แล้ว +6

    Dear Leila, hope you're having a great day. Firstly, thank you for sharing your Excel knowledge with us.This technic is highly usable and your channel is great. Secondly I want to ask you, if I may: why not to use the dynamic chart resource derived from an pivot table and which one do you prefer? Thanks!

  • @Betterifitsfree
    @Betterifitsfree 6 ปีที่แล้ว

    I love watching these videos. It's like a beautiful TV weather girl telling you how nice it will be tomorrow and when she is done, you are like...."what did she just say?"

  • @AbhishekTripathidce
    @AbhishekTripathidce 4 ปีที่แล้ว

    This is really fantastic. thank you for this video and million of thanks for your effort for making and uploading .

  • @ririraman7
    @ririraman7 2 ปีที่แล้ว

    Thank you so much ma'am.

  • @osham5206
    @osham5206 4 ปีที่แล้ว

    It's awesome, simple & organized Leila. Great Job :)

  • @satyasrinivas480
    @satyasrinivas480 6 ปีที่แล้ว

    Leila, Excellent video on Dynamic Chart. So kind of you. Thanks a lot for your tutorial. :)

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      You're very welcome Satya. Gald you like it.

  • @shockhopful
    @shockhopful 6 ปีที่แล้ว

    I've watching your videos for the past month! THANK YOU SO MUCH!!! YOU'VE SAVED ME SO MANY TIMESS!

  • @abhishekkedia9859
    @abhishekkedia9859 4 ปีที่แล้ว

    Great Content.Loved It.Keep this coming.

  • @johnalexisfranco8265
    @johnalexisfranco8265 4 ปีที่แล้ว

    Thanks for the index match tutorial. I'm learning this other one too!

  • @victorcox3227
    @victorcox3227 4 ปีที่แล้ว

    Just Brilliant!! you amaze me

  • @afzauddin7634
    @afzauddin7634 5 ปีที่แล้ว

    Hi Leila Gharani
    I'm always watching your video and practice in my Laptop, thanks for explanation, I don't know influence English but I understood very well. few days before I was send comment but that is still no answer, but I like your videos thumps up 👍

    • @LeilaGharani
      @LeilaGharani  5 ปีที่แล้ว

      Glad you like the videos!

  • @karinalopezhuitron6003
    @karinalopezhuitron6003 2 ปีที่แล้ว

    You totally rock!

  • @rienthongw
    @rienthongw 6 ปีที่แล้ว

    You are my angle. This VDO can help me to make a great presentation. Thank you so much. :)

    • @LeilaGharani
      @LeilaGharani  6 ปีที่แล้ว

      You're very welcome & I'm very happy to hear you find it useful for your work :)

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

    wow i am blown away.

  • @Williams76
    @Williams76 21 วันที่ผ่านมา

    Good job

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

    Good video! I agree. Having a prep area is easier to manage and troubleshoot than a named range.

  • @wilfortdanielpenafernandez373
    @wilfortdanielpenafernandez373 5 ปีที่แล้ว

    THANK YOU FOR ALL YOU ARE THE BEST

  • @flightforge30
    @flightforge30 6 ปีที่แล้ว

    perfect teacher for excel!!!

  • @namelyaanuar5665
    @namelyaanuar5665 4 ปีที่แล้ว

    OMG!!!! Thank you so much for this!!!!! I’ve been doing in vba which i have to specify it one by one 😭😭😭 thank you for saving my time!!!

    • @LeilaGharani
      @LeilaGharani  4 ปีที่แล้ว

      Glad it's useful for you :)

  • @ViktorNikolov93
    @ViktorNikolov93 4 ปีที่แล้ว

    Thank you so much for the added value. :)