Excel Dynamic Chart with Drop down List (column graph with average line)
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Learn how to create an interactive chart in Excel that switches views depending on the selection from the drop-down list. In addition to creating dynamic chart ranges, I also show you how to create combo or combination charts in Excel.
⬇️ Download the workbook here: pages.xelplus.com/dynamic-cha...
In this specific example, I show you how to add a horizontal average line to your column chart. This makes it simple to compare the values of the bars not just with one another but also with the average.
The key to dynamic charts is to create a data preparation table that sits between your raw data and your chart. Smart Excel formulas help you do this dynamically. In this example, I use the Index and Match formula for data preparation.
🔍 What You'll Learn:
- How to set up a dropdown menu to control chart data.
- Creating a data preparation table for dynamic chart updates.
- Combining INDEX and MATCH functions for precise data extraction.
👩💼 Perfect for:
- Excel users looking to add interactivity to their charts.
- Professionals in sales, marketing, or any field requiring data comparison.
- Excel enthusiasts keen on enhancing their spreadsheet skills.
📌 Key Highlights:
- Control your charts with simple dropdown selections.
- Leverage Excel functions for dynamic data updates.
- Improve your charts with additional features like average lines.
Links to related videos:
Index Match Basics: • How to use Excel Index...
Excel Charts Basics: • Excel Charts & Graphs:...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Пікірлер: 342
Grab the file I used in the video from here 👉 pages.xelplus.com/dynamic-chart-file
I love this lady - and her tutorials are so concise and clear.
you are by far the best excel instructor on youtube
@LeilaGharani
6 жыл бұрын
Thank you very much for the kind words - there are great Excel channels on KZread - the fact that you think mine is good does mean a lot. Thank you for your support.
@indradevdubey
4 жыл бұрын
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
4 жыл бұрын
@@LeilaGharani You are the best Excel instructor in KZread
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
6 жыл бұрын
This made me smile :) Thank you Adi for your comment. I'm glad to hear you enjoy the courses.
Best excel teacher in youtube, I will be definetely enrolling in one of your courses!
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 :)
I've watching your videos for the past month! THANK YOU SO MUCH!!! YOU'VE SAVED ME SO MANY TIMESS!
I want to thank you 1.000.000 times for your teaching method and share the workbook , I appreciate and grateful for your channel
As usual, Leila makes it easier. No complex explanation, no jargons. Simple presentation that anyone can understand
Worked like a charm, thank you greatly!
Simplicity at its best!!!!. I really appreciate the way you explain things. Great work.. keep it the way it is...
@LeilaGharani
6 жыл бұрын
Thanks a lot! Glad you like it :)
Hi Leila, Very simple and well explained. I am specializing in excel after seeing your excel video. Thanks a Lot
So easy to follow up. Absolutely not boring. You are smart and also beautiful. Keep it up. Greetings from Azerbaijan.
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.
Thank you for your helpful video lessons.
Great explanation, Thanks.
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!
This was exactly what I was looking for. AND - you made it sound so easy. Can't thank you enough....
Excellent. It helped Again. Leila has given all the Solutions for all the Practical Issues. Thanks again.
well explained, thanks!
I call her the Queen of Excel. Thank you Leila🥰
very useful for the charting.Thanks
Pretty awesome video! Many thanks!
Great explanation and easy to follow, thank you so much.
I am impressed! congrats and a big thank you🙏
Very crisp and clear
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).
Thank youuuuuuuuuu. I was looking for this
Outstanding, as usual. Thank you very much.
Thanks for the index match tutorial. I'm learning this other one too!
EXCELlent presentation Leila!
Exact video I looking for me & clear all doubt in One watch only... Great
This is really fantastic. thank you for this video and million of thanks for your effort for making and uploading .
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!).
This is super awesome. Love how you make it simple for me to understand lol Ps :my boss was impressed when i did the custom formatting magic happened on my NPS report..the one with the smileys lol big fan of your data visualisation techniques :)
@LeilaGharani
6 жыл бұрын
Thanks Alvin for your comment - That's great about your boss! simple tricks go a long way :)
It's awesome, simple & organized Leila. Great Job :)
Really Nice I'm an excel freak and I love the way you explain
Very well explained, its amazing
absolutely amazing trick, thanks for sharing
You are one of the best Excel tutor in the KZread especially teaching complex things in simple steps......Thanks a lot..
@LeilaGharani
5 жыл бұрын
Thank you for the kind words!
Amazing !! Thank you very much.
Thank you so much! This video is very clear and useful!
Very nice. Awesome techniques
Great Content.Loved It.Keep this coming.
Thank you so much for the added value. :)
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❤️
Excellent! You are so smart! Thank you!
Hi Leila, Your videos are really helping me to understand excel, I truly appreciate the work you have put in.
@LeilaGharani
6 жыл бұрын
Thank you David for your comment & support! I'm glad you find the videos useful :)
I love you Leila, you saved my day
perfect teacher for excel!!!
You really explain things in a very easy manner. Cool !! Good call!. Please put more videos like this ..Thank you
Awesome. Thanks.
Just Brilliant!! you amaze me
Definitely 1 of the best excel Instructors...Learned and still learning a lot from your videos...keep the good Work up.. God Bless
@LeilaGharani
4 жыл бұрын
Thank you for the kind words. I'm glad you find the tutorials helpful.
You totally rock!
You are a genius!! Thanks
Thanks Leila Gharani. very well explained!!
Thanks a lot for this video. Alleviated my frustrations quite a bit
Wow, your vids are State of the Art. Thanks ever so much for these. Can’t believe these are available for free 🤩
@LeilaGharani
2 жыл бұрын
Glad you like them!
You are wonderful👍🏻
Very good instruction. short and to the point!! thank you. Also you gave many tips for issues which I struggled with!
@LeilaGharani
5 жыл бұрын
You're very welcome. I'm glad the tutorial is helpful.
Always your video will help to improve my skill in excel
Thank you Leila.
its easy and you are the best ever
Thank you soo much.
A very informative and helpful
Thank you so much ma'am.
Fantastic!
Once again, goddess of excel helped me out.
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
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
6 жыл бұрын
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.
Really I like videos , its very helpful
Thank you!
Definitely the best excel instructor on you tube. Very professional!
@LeilaGharani
3 жыл бұрын
Wow, thanks Michael!
You're god sent.. Love from INDIA
Great video, you use simple words and make things so clear and easy.
@LeilaGharani
5 жыл бұрын
I'm very glad to hear that. Thanks for your support.
Dear ma'am Excellent information.i am one of your regular learner of your video Thanks
Very useful video of course
good one and easy to learn. thanks for the Video
@LeilaGharani
5 жыл бұрын
Glad you like the tutorial.
thank you so much mam.wonderful video
This is great! Thank you! :)
THANK YOU FOR ALL YOU ARE THE BEST
Hi!Leila, I am very much impressed by the way you teach excel. Now let me know whether I can insert table for the array so that I may keep on updating data bring into the dropdown list.
Really love to learn all the lesson on excel. Thank you mam. Saif from India. 🎉
Thank you for sharing. Please do more tutorials with financial charts and graphs.
Congratulations and thank you, your video really helps me in providing a very valuable and dynamic data analysis
@LeilaGharani
6 жыл бұрын
Thank you for your comment. I'm very glad you find the content useful.
Leila, thank you so very much for taking your time to prepare Excel videos.
@LeilaGharani
6 жыл бұрын
You're very welcome. Thank you for watching, commenting & supporting.
@aek3945
6 жыл бұрын
My pleasure...Also, do you have videos on preparing a budget? Kind regards,
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
6 жыл бұрын
Thank you Fernando for your very nice comment. I am glad to hear you like the videos : )
Excellent idea. Thanks for sharing knowledge.
@LeilaGharani
6 жыл бұрын
You're very welcome.
You are the art of mastering..
Great job. Thanks for sharing.
@LeilaGharani
6 жыл бұрын
Thanks Craig & you're very welcome.
Lovely work Leila. Thank u so much. Being a beginner trying to work around. Great help !!!
@LeilaGharani
5 жыл бұрын
I'm glad it's helpful!
I got that in one go with the help of this video, amazing, thank you so much for these quick and easy tutorials :) :)
@LeilaGharani
3 жыл бұрын
Great to hear!
Thanks, excellent work, you got a new subscriber
@LeilaGharani
4 жыл бұрын
Great! Glad to have you here.
Класс! Ваши видео самые лучшие:)
EXCELLENT, Your are the best excel teacher. wonderful Leila, Thanks
@LeilaGharani
4 жыл бұрын
Thanks for the kind words!
Good video! I agree. Having a prep area is easier to manage and troubleshoot than a named range.
@LeilaGharani
6 жыл бұрын
Thanks Oz :)
Nice explanation and presentation. Thank you so much for your guidance
@LeilaGharani
5 жыл бұрын
You're very welcome. Glad you like the video.
Your videos have helped me become much better at my job.....thanks!
@LeilaGharani
6 жыл бұрын
You're welcome Josh! I'm very happy to hear that. Thanks for your comment.
wl mam ur teaching level is very god i am satisfied about ur lecture
Thank you so much. I am not good in charts and i was looking for this and finally i learned it.
@LeilaGharani
4 жыл бұрын
That's great to hear. I'm glad the tutorial is helpful.