Excel Charts & Graphs: Learn the Basics for a Quick Start

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Learn the basics of Excel charts to be able to quickly create graphs for your Excel reports. We walk you through the essentials of Excel charts, including how to insert, adjust, and enhance them. You'll also learn about adding multiple series and crafting combination charts to make your data presentations stand out.
Grab the file I used in the video from here 👉 pages.xelplus.com/charts-basi...
🔑 Key Learnings:
▪️ Step-by-step instructions on inserting charts in Excel.
▪️ Guidance on adjusting and enhancing chart elements for clarity.
▪️ Techniques for adding multiple series to your charts.
▪️ How to create combination charts, like combining column and line charts.
▪️ Tips for making your charts more professional and visually appealing.
▪️ Utilizing shortcuts and tools for efficient chart creation.
The type of Excel charts covered are column, bar, line and a combination of column and line chart. Use these charts to make comparisons or show trends. You'll also learn how to create combination charts to show more than one variable or multiple data sets.
00:00 How to Create Charts in Microsoft Excel
00:28 How to insert an Excel Chart
03:30 How to Adjust / Edit the Chart
06:28 Tips to Create Professional Excel Charts
07:50 How to Add More Series to an Excel Chart
10:10 How to Create Combination Charts (Column with Line Chart)
Links to related videos:
Chart Playlist on KZread ► • Excel Charts
Using shapes in charts (non-standard graphs): • This Excel Chart will ...
➡️ 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

Пікірлер: 346

  • @LeilaGharani
    @LeilaGharani6 жыл бұрын

    Grab the file I used in the video from here 👉 pages.xelplus.com/charts-basics-file Are there any specific chart topics you'd like me to cover? Let me know in the comments below.

  • @jp16

    @jp16

    6 жыл бұрын

    Leila Gharani. hi. i would like to know if its possible to create pie chart instead using the example in this clip. n lets say if i drop down a list in cell c2 (which contain the name). the selected name would "stand out" in the pie chart. i tried using the primary/seconday method as i will do for a line chart. but seems to me pie chart dun allow primary/seconday.

  • @michaeldiamond2726

    @michaeldiamond2726

    6 жыл бұрын

    Hi Leila, Great video Leila. It really explain the chart mechanics. Is this part of your dashboard course? If it isn't I think it should be added. Michael

  • @amitkumar-ip6yv

    @amitkumar-ip6yv

    6 жыл бұрын

    Doughnut chart

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    Thanks Michael. That's a good suggestion :)

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    Hi JP - Pie charts are not as easy to read as sorted bar / column charts. Check out this video for more info: kzread.info/dash/bejne/qoOTzqWCcc_UhpM.html

  • @knowledgepeace4848
    @knowledgepeace48482 жыл бұрын

    Hello Leila, I enjoy watching your videos a lot. It would be good if you did include the exercise files for people to practice your teaching videos. I know a lot of people including myself would appreciate it even more. Thank you.

  • @Mz_lady
    @Mz_lady3 жыл бұрын

    This is the best chart tutorial I've found! Quick, to the point, easy to understand :) And you taught some nice shortcuts!

  • @kushagarwal8953
    @kushagarwal89535 жыл бұрын

    Also found this video useful alike your any other excel video. Best part is you start from the base and take it to the end. Thank a lot !!

  • @zaidyounas1602

    @zaidyounas1602

    4 жыл бұрын

    you'd still not gonna get the bobs tho

  • @jmdd3162
    @jmdd31626 жыл бұрын

    as usual this has been a very good video leila, thanks a lot!

  • @joshuateo8456
    @joshuateo84566 жыл бұрын

    Congratulation for winning the Most Valuable Professional (MVP) award from Microsoft. Thank you for your valuable sharing on Excel which I benefited from it tremendously. Once again, thank you and Congratulation.

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    Thank you very much Thomas for your support and the kind words.

  • @Mahendrababu56
    @Mahendrababu565 жыл бұрын

    Thank You So Much!!!.. The concept you are explaining is very clear in each video!! Keep doing the Good Work !! We are looking forward to your upcoming New concepts!!!

  • @Aricabacuto
    @Aricabacuto4 жыл бұрын

    A very very nice explanation, calmly and precise ... especially for those who speak English like a second language.

  • @catherinemaingi6767
    @catherinemaingi67675 жыл бұрын

    thank you - very simply done and detailed.

  • @workinglivingtravellingini999
    @workinglivingtravellingini9994 жыл бұрын

    First video I have watched, it has helped me to understand some very basics I never really understood before. Thanks!

  • @solsmacs.3552
    @solsmacs.35525 жыл бұрын

    Super easy to follow. thank you for your time in this.

  • @ricardoacevedo4811
    @ricardoacevedo48112 жыл бұрын

    Hi Leila, I enjoyed your calm and softspoken way of presenting, and of course the useful information for inserting, adjusting and working with charts in general. I will most likely be watching more of your videos. Today I subsribed to you channel. Thanks again, Ricardo

  • @ginotarabotto
    @ginotarabotto5 жыл бұрын

    You're an awesome tutor, thank you! And happy 2019.

  • @lifeofkiran6285

    @lifeofkiran6285

    3 жыл бұрын

    Same from 2021 thank you !!!!

  • @temirlanmukatay1765
    @temirlanmukatay17654 жыл бұрын

    Thank you!!!Your videos are really helpful.Continue that way

  • @margaretdsouza3782
    @margaretdsouza37822 жыл бұрын

    Thank you Leila. Well explained and very useful. Stay Blessed!

  • @shilpavaidya1077
    @shilpavaidya10775 жыл бұрын

    Leila The videos are very useful and to the point! Thank you

  • @powerbiselfstudyguide
    @powerbiselfstudyguide2 ай бұрын

    The Best Tutorial on KZread on Excel Charts Basics. This is point to point video and cover all important aspects as well. Keep it up!

  • @LeilaGharani

    @LeilaGharani

    2 ай бұрын

    Much appreciated!

  • @ferozabuzar2805
    @ferozabuzar28054 жыл бұрын

    Thanks very much Leila for the great job...! i am learning so much from you

  • @dipanjansaha1389
    @dipanjansaha13895 жыл бұрын

    All your videos are really helpful and I have a new found appreciation for excel :)

  • @almiraviani
    @almiraviani Жыл бұрын

    such a brilliant tutorial! thank you for your time & effort!

  • @kasiabarszczyk9970
    @kasiabarszczyk9970 Жыл бұрын

    Very helpful, lots of extra tips that other tutorials don't mention, thank you!

  • @KarenZappavignaHoogland
    @KarenZappavignaHoogland6 жыл бұрын

    Thanks for this tutorial - very helpful information.

  • @Anikvikram
    @Anikvikram Жыл бұрын

    Thank you Ma'am, its very helpful.

  • @Drkalaamarab
    @Drkalaamarab4 жыл бұрын

    Madam, your great demonstration made me to learn things hassle free. You explain it detailely which help to understand each steps. Thank you very much. Could you please post on - How to Analyze Text Data , Text Analysis by using Excel step by step .

  • @valdannofernandes7984
    @valdannofernandes79842 жыл бұрын

    You just make things so clear. Thanks.

  • @Dhanesh87
    @Dhanesh87 Жыл бұрын

    Thank you Leila this video was very informative, short and helpful.

  • @Sophia-nw2bk
    @Sophia-nw2bk3 жыл бұрын

    Very well explained and easy to follow.

  • @jamesdowey6943
    @jamesdowey69437 ай бұрын

    Very well explained!! Thank you Jim

  • @ZAHIDHUSSAIN-ri5kg
    @ZAHIDHUSSAIN-ri5kg6 жыл бұрын

    Many, Many Thanks Leila! it was wonderful. Thanks for sharing.

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    Glad you find it useful Zahid.

  • @hbfromkc
    @hbfromkc3 жыл бұрын

    thank you for getting to the point!!! i was having a hard time and literally understood how to add a chart within one minute!

  • @LeilaGharani

    @LeilaGharani

    3 жыл бұрын

    Glad it was helpful!

  • @ckokse
    @ckokse5 жыл бұрын

    As always simple and to the point. You are the best!

  • @LeilaGharani

    @LeilaGharani

    5 жыл бұрын

    Thanks. I'm glad you like it :)

  • @brshankar2010
    @brshankar20105 жыл бұрын

    Good presentation, thanks for that.

  • @peacetruth5243
    @peacetruth5243 Жыл бұрын

    Thank you so much :) Very easy to follow. My first chart is done! Yey!!!

  • @danielgheorghe2912
    @danielgheorghe29125 жыл бұрын

    Good job! Thank you!

  • @FranciscoVegagranmusica
    @FranciscoVegagranmusica5 жыл бұрын

    Just to say you Leila that I am your Fan and your student number one, thanks to teach Excel

  • @abdullahibrahimjawad2648
    @abdullahibrahimjawad26486 жыл бұрын

    Excellent! Thanks very much for the video....

  • @lxmoomum
    @lxmoomum6 жыл бұрын

    Thank you!!! I am 2 days away from submitting my final project and have been scrambling around the internet for Standard Deviation charting in excel, when I came across your channel. WOW just watching this video, I have learnt so much and will dig deeper to see if you have SDEV help, but if not, would be grateful for a video on this.

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    I'm glad you find the videos useful. I currently don't have anything on SDEV..... that's a good point though. Good luck on your exam!

  • @uniquetamaaria1540
    @uniquetamaaria15405 жыл бұрын

    I'm going to subscribe to channel now. It's informative and more detailed unlike the others I have watched so far.

  • @Sparqcorporatetraining
    @Sparqcorporatetraining Жыл бұрын

    Outstanding, as always!

  • @MikeyJLH
    @MikeyJLH4 жыл бұрын

    Hi there, I've been using charts from 2008 up and the elements seem to be getting easier to use. Although I have struggled a bit, these tutorials are like fresh air. Great work and better that reading through Microsoft's help page.

  • @LeilaGharani

    @LeilaGharani

    4 жыл бұрын

    Glad you like the tutorials Michael.

  • @aviadavraham77
    @aviadavraham773 жыл бұрын

    SUPER USEFUL !! THANK YOU

  • @tigersharma1443
    @tigersharma14432 жыл бұрын

    Your teaching is very Clean and clear and next level .

  • @LeilaGharani

    @LeilaGharani

    2 жыл бұрын

    Glad to hear that!

  • @marcuspow
    @marcuspow5 жыл бұрын

    thank you so much this is really helpful.

  • @RTMEX
    @RTMEX3 жыл бұрын

    Leila Gharani Very good presentation BEST REGARDS

  • @Proton-KB
    @Proton-KB Жыл бұрын

    This was really well done to explain to me the basics of charts, ty kindly.

  • @darrengodkin
    @darrengodkin6 жыл бұрын

    Great top tips, generally at work due to time constraints, I normally just knock a quick chart up from self taught learning, very ad hoc and messy. Not any more after watching this great video. Thanks Darren

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    I'm glad you find the tips useful Darren - yes- usually time constraints don't go hand-in-hand with nice charts :)

  • @vedavathivedavathi9045
    @vedavathivedavathi90454 жыл бұрын

    I really like this video. I know understood properly and thank you so much for doing this video 👍👌☺

  • @eradotcom
    @eradotcom28 күн бұрын

    thanks Leila for the basic feature chart explanation🙏

  • @LeilaGharani

    @LeilaGharani

    27 күн бұрын

    You're welcome 😊

  • @djchino774
    @djchino774Ай бұрын

    Thank you!

  • @dyaneespinosa8014
    @dyaneespinosa80145 жыл бұрын

    I think this is a great training video for beginners like me! Thank you!

  • @LeilaGharani

    @LeilaGharani

    5 жыл бұрын

    Thank you! I'm glad you find it helpful :)

  • @eltigrillopintito
    @eltigrillopintito2 жыл бұрын

    So awesome to learn all this. TY so much and the best for you

  • @violetdeluxe
    @violetdeluxe6 жыл бұрын

    Hey nice job - thanks!

  • @riazhossain580
    @riazhossain5804 жыл бұрын

    Thank you so much Leila. This is really easy to understand for a beginner like me.

  • @LeilaGharani

    @LeilaGharani

    4 жыл бұрын

    You’re welcome 😊

  • @KendraLock
    @KendraLock4 жыл бұрын

    Awesome video. Easy to understand. Very helpful. Thank you.

  • @LeilaGharani

    @LeilaGharani

    4 жыл бұрын

    Glad it was helpful Kendra!

  • @giorgidvali951159
    @giorgidvali9511592 ай бұрын

    I love all of your videos.

  • @administrativeassistant-co6985
    @administrativeassistant-co69853 жыл бұрын

    Very well done, thank you.

  • @sunnyhu4855
    @sunnyhu48555 жыл бұрын

    I like this video. You are a good teacher.

  • @blackeagle336
    @blackeagle336 Жыл бұрын

    really good, so clear and instructive even 5 years later!! thank you!

  • @LeilaGharani

    @LeilaGharani

    Жыл бұрын

    You're very welcome!

  • @Simpletitbit123
    @Simpletitbit12311 ай бұрын

    I like your tutorials. It is explained in a very simple language. keep it up.

  • @amerabdelbaky4235
    @amerabdelbaky423511 күн бұрын

    great as usuall

  • @DardouriNezha
    @DardouriNezha5 жыл бұрын

    Thank You Very Much!!!..

  • @excelisfun
    @excelisfun6 жыл бұрын

    Thanks for the Double Basic Fun today!!! Notice in your example that Recommend Chart suggests a pie to the user... no pie, except today for Thanksgiving : )

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    :) true. Happy Thanksgiving!

  • @excelisfun

    @excelisfun

    6 жыл бұрын

    Apple, Pumpkin and Pecan pie is okay today : )

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    Yum! I remember in Canada they had the best Pecan pies....unfortunately nothing like it here in Austria.....

  • @excelisfun

    @excelisfun

    6 жыл бұрын

    You can get one in Excel with the =PECANPIEINAUSTRIA() Function !!!!

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    Good point! I should make my own :)

  • @sunnyday8186
    @sunnyday81862 жыл бұрын

    Thanks so much! This video is so good and helpful. You explanation always make things easy to understand.

  • @LeilaGharani

    @LeilaGharani

    2 жыл бұрын

    Glad it was helpful, Anita!

  • @juicesapfjori9370
    @juicesapfjori93703 жыл бұрын

    Thank you very much! This was very thorough and helpful.

  • @LeilaGharani

    @LeilaGharani

    3 жыл бұрын

    Glad you enjoyed it!

  • @stephj765RS
    @stephj765RS4 жыл бұрын

    Wow that's awesome. Crystal clear !

  • @LeilaGharani

    @LeilaGharani

    4 жыл бұрын

    Glad you like it.

  • @Dev_Bartwal
    @Dev_Bartwal6 жыл бұрын

    Great class LG💕

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    Thanks Dev.

  • @douglaszulu6281
    @douglaszulu62816 жыл бұрын

    Great chart tools and insights Leila

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    Thank you Douglas :) Looking forward to yours.

  • @JB-ty8mv
    @JB-ty8mv2 жыл бұрын

    I am impressed with your content and teaching style. Excellent!!

  • @LeilaGharani

    @LeilaGharani

    2 жыл бұрын

    I appreciate that!

  • @aykutyldz1538
    @aykutyldz15382 жыл бұрын

    thank you very much for this fantastic tutorial

  • @mahsaomrauni
    @mahsaomrauni4 жыл бұрын

    you are the best teacher Leila

  • @raghuv7114
    @raghuv71144 жыл бұрын

    it's Well received.Now my target is on excell charts to understand completely and to learn within a week.

  • @1gopalakrishnarao
    @1gopalakrishnarao6 жыл бұрын

    Great tutorial indeed. Once again no words to explain your good deeds, BIG & VERY BIG ROYAL SALUTE TO YOU MADAM. Waiting eagerly to learn more and more in the days to come. We are very lucky indeed to get a great teacher/guru in Excel like you, which no one can compete. Yours greatest admirer/follower/disciple - Gopalakrishna

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    Thank you very much Gopala for the very kind words! I am very happy you find the videos useful. I am no guru though - still have a lot to learn myself :)

  • @1gopalakrishnarao

    @1gopalakrishnarao

    6 жыл бұрын

    Guruji, It shows your greatness!!!!!!!!!! once again a big salute.

  • @Dichak2
    @Dichak2 Жыл бұрын

    Too many good information 😊haha Not complaining just enjoyed it. Thank you 🙏🏿

  • @krishnaacharya4001
    @krishnaacharya40014 жыл бұрын

    Hi Leila , Thank you for providing such a great course to us. I want to watch all of your videos , but just don't know where to start from , as there are many playlists out there can you please let me know the sequence in which i need to watch your videos , so that i can make most out of it . Thank You .

  • @xolani2321
    @xolani23212 жыл бұрын

    At first I was distracted lol but I caught up very fast . Thanks Leila topics well presented

  • @mixme8655
    @mixme86556 жыл бұрын

    Thank you very much Ms Leila

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    You're very welcome.

  • @simonjones3224
    @simonjones32243 жыл бұрын

    Thanks Leila. It took me ages to find how to stop excel from grouping items in a dataset.

  • @meenakshivarshney1796
    @meenakshivarshney17964 жыл бұрын

    Thanks so much

  • @irviantantohaditomo8917
    @irviantantohaditomo89176 жыл бұрын

    Good videos. I can improving my skills. Thank you.

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    You're very welcome! I'm glad to hear that.

  • @sharonwanjiku9403
    @sharonwanjiku94035 жыл бұрын

    very helpful thanks

  • @brandcutpiecehouse
    @brandcutpiecehouse4 жыл бұрын

    Very informative and helpful video

  • @pavithradissanayaka6356
    @pavithradissanayaka63564 жыл бұрын

    thanks so much for the video

  • @tigereltoro
    @tigereltoro Жыл бұрын

    Awesome tutorial ! Thank you! :)

  • @LeilaGharani

    @LeilaGharani

    Жыл бұрын

    Glad you enjoyed it!

  • @Pops113
    @Pops1132 жыл бұрын

    You’re a legend thank you!!

  • @clearconcept12
    @clearconcept123 жыл бұрын

    Very informative 👍

  • @Faz527
    @Faz5273 жыл бұрын

    Amazing video! Learnt a lot. Nice explanation.

  • @LeilaGharani

    @LeilaGharani

    3 жыл бұрын

    Glad to hear that!

  • @anikchowdhury9708
    @anikchowdhury9708 Жыл бұрын

    Thank you so much.

  • @joykarmaker2604
    @joykarmaker26044 жыл бұрын

    i have been a staunch follower of this channel . Just one request, please give the link of sample worksheet under every video description you used for each tutorial. Upon and while watching we need practice in home

  • @ismailismaili0071
    @ismailismaili00716 жыл бұрын

    Thank u so much Ms. Leila it was really really useful and I've learned a lot from it waiting the next video hhh

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    You're very welcome Ismail.

  • @ismailismaili0071

    @ismailismaili0071

    6 жыл бұрын

    by the way happy thanksgiving

  • @apachespyder
    @apachespyder4 жыл бұрын

    Very good video at a great pace. Thank you.

  • @LeilaGharani

    @LeilaGharani

    4 жыл бұрын

    Glad you liked it Sean!

  • @funnysun3291
    @funnysun32915 жыл бұрын

    thanks great one

  • @lolilolita8502
    @lolilolita85026 жыл бұрын

    Very good presentation. I love the way you teach it.

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    I'm glad you like the teaching! Thank you.

  • @aberakifetew13
    @aberakifetew13 Жыл бұрын

    really it is very good explanation and very easy to learn.

  • @lawrencekazibwe9751
    @lawrencekazibwe97512 жыл бұрын

    Thanks alot Leila

  • @ahsanullahafridi9570
    @ahsanullahafridi95706 жыл бұрын

    I love it as always.

  • @LeilaGharani

    @LeilaGharani

    6 жыл бұрын

    Thank you! Glad you like it.

  • @FaysalEasyExcel
    @FaysalEasyExcel4 жыл бұрын

    you are awesome. thanks.

  • @shahnawazshaikh1282
    @shahnawazshaikh12822 жыл бұрын

    Very well explained...

  • @abulhassanalbulushi6880
    @abulhassanalbulushi68805 жыл бұрын

    Excelente job!.. Thanks a lot

  • @LeilaGharani

    @LeilaGharani

    5 жыл бұрын

    You're very welcome. Glad you like it.

  • @bashinidulshara1943
    @bashinidulshara1943 Жыл бұрын

    Thnk u so much , it's valuble vedio , again tnx 😀

  • @dillipaudel575
    @dillipaudel5755 жыл бұрын

    Thank Leila for this very useful video.

  • @LeilaGharani

    @LeilaGharani

    5 жыл бұрын

    My pleasure. I'm glad it's useful.