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

Поделиться
HTML-код
  • Опубликовано: 25 июн 2024
  • 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 RUclips ► • 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

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

  • @LeilaGharani
    @LeilaGharani  6 лет назад +46

    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 лет назад +2

      Hi JP - Pie charts are not as easy to read as sorted bar / column charts. Check out this video for more info: ruclips.net/video/xO_lCIAlnV0/видео.html

  • @Mz_lady
    @Mz_lady 3 года назад +11

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

  • @kushagarwal8953
    @kushagarwal8953 5 лет назад +17

    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

  • @knowledgepeace4848
    @knowledgepeace4848 2 года назад +21

    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.

  • @jmdd3162
    @jmdd3162 5 лет назад +10

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

  • @joshuateo8456
    @joshuateo8456 6 лет назад +19

    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 лет назад +2

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

  • @catherinemaingi6767
    @catherinemaingi6767 5 лет назад +1

    thank you - very simply done and detailed.

  • @solsmacs.3552
    @solsmacs.3552 5 лет назад

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

  • @Mahendrababu56
    @Mahendrababu56 5 лет назад

    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!!!

  • @powerbiselfstudyguide
    @powerbiselfstudyguide Месяц назад

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

  • @ginotarabotto
    @ginotarabotto 5 лет назад +2

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

  • @temirlanmukatay1765
    @temirlanmukatay1765 4 года назад

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

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

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

  • @KarenZappavignaHoogland
    @KarenZappavignaHoogland 5 лет назад

    Thanks for this tutorial - very helpful information.

  • @Aricabacuto
    @Aricabacuto 4 года назад +2

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

  • @ricardoacevedo4811
    @ricardoacevedo4811 2 года назад +3

    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

  • @almiraviani
    @almiraviani Год назад +1

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

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

    You just make things so clear. Thanks.

  • @dipanjansaha1389
    @dipanjansaha1389 5 лет назад

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

  • @ferozabuzar2805
    @ferozabuzar2805 4 года назад

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

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

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

  • @Sophia-nw2bk
    @Sophia-nw2bk 3 года назад +1

    Very well explained and easy to follow.

  • @kasiabarszczyk9970
    @kasiabarszczyk9970 Год назад

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

  • @brshankar2010
    @brshankar2010 5 лет назад

    Good presentation, thanks for that.

  • @shilpavaidya1077
    @shilpavaidya1077 5 лет назад +1

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

  • @Dhanesh87
    @Dhanesh87 Год назад

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

  • @danielgheorghe2912
    @danielgheorghe2912 5 лет назад

    Good job! Thank you!

  • @jamesdowey6943
    @jamesdowey6943 6 месяцев назад

    Very well explained!!
    Thank you
    Jim

  • @abdullahibrahimjawad2648
    @abdullahibrahimjawad2648 5 лет назад

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

  • @Anikvikram
    @Anikvikram Год назад +1

    Thank you Ma'am, its very helpful.

  • @ZAHIDHUSSAIN-ri5kg
    @ZAHIDHUSSAIN-ri5kg 6 лет назад

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

  • @marcuspo5211
    @marcuspo5211 5 лет назад

    thank you so much this is really helpful.

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

    SUPER USEFUL !! THANK YOU

  • @ckokse
    @ckokse 5 лет назад

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

  • @peacetruth5243
    @peacetruth5243 Год назад

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

  • @violetdeluxe
    @violetdeluxe 6 лет назад

    Hey nice job - thanks!

  • @vedavathivedavathi9045
    @vedavathivedavathi9045 4 года назад

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

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

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

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

    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 .

  • @administrativeassistant-co6985
    @administrativeassistant-co6985 3 года назад

    Very well done, thank you.

  • @DardouriNezha
    @DardouriNezha 5 лет назад

    Thank You Very Much!!!..

  • @Proton-KB
    @Proton-KB Год назад

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

  • @sunnyhu4855
    @sunnyhu4855 5 лет назад

    I like this video. You are a good teacher.

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

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

  • @dyaneespinosa8014
    @dyaneespinosa8014 5 лет назад

    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 :)

  • @martinhodge394
    @martinhodge394 4 года назад

    Thank you!

  • @Sparqcorporatetraining
    @Sparqcorporatetraining 11 месяцев назад

    Outstanding, as always!

  • @uniquetamaaria1540
    @uniquetamaaria1540 5 лет назад

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

  • @anikchowdhury9708
    @anikchowdhury9708 Год назад

    Thank you so much.

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

    thank you very much for this fantastic tutorial

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

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

  • @FranciscoVegagranmusica
    @FranciscoVegagranmusica 5 лет назад

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

  • @blackeagle336
    @blackeagle336 Год назад

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

  • @sharonwanjiku9403
    @sharonwanjiku9403 5 лет назад

    very helpful thanks

  • @riazhossain580
    @riazhossain580 4 года назад

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

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

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

  • @KendraLock
    @KendraLock 4 года назад

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

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

    Thanks so much

  • @MikeyJLH
    @MikeyJLH 4 года назад +5

    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.

  • @Simpletitbit123
    @Simpletitbit123 10 месяцев назад

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

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

    Leila Gharani
    Very good presentation
    BEST REGARDS

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

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

  • @pavithradissanayaka6356
    @pavithradissanayaka6356 4 года назад

    thanks so much for the video

  • @stephj765RS
    @stephj765RS 4 года назад

    Wow that's awesome. Crystal clear !

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

    Your teaching is very Clean and clear and next level .

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

    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 .

  • @douglaszulu6281
    @douglaszulu6281 6 лет назад

    Great chart tools and insights Leila

    • @LeilaGharani
      @LeilaGharani  6 лет назад

      Thank you Douglas :) Looking forward to yours.

  • @irviantantohaditomo8917
    @irviantantohaditomo8917 6 лет назад

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

    • @LeilaGharani
      @LeilaGharani  6 лет назад

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

  • @Pops113
    @Pops113 Год назад

    You’re a legend thank you!!

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

    Very informative 👍

  • @funnysun3291
    @funnysun3291 5 лет назад

    thanks great one

  • @darrengodkin
    @darrengodkin 6 лет назад

    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 :)

  • @raghuv7114
    @raghuv7114 4 года назад

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

  • @giorgidvali951159
    @giorgidvali951159 Месяц назад

    I love all of your videos.

  • @mixme8655
    @mixme8655 6 лет назад

    Thank you very much Ms Leila

  • @aberakifetew13
    @aberakifetew13 Год назад

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

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

    Very informative and helpful video

  • @YogeshSharma-ee8ml
    @YogeshSharma-ee8ml 3 года назад

    Thanks, you made simple things looks hard.

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

    Thanks!

  • @JB-ty8mv
    @JB-ty8mv 2 года назад

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

  • @xolani2321
    @xolani2321 Год назад

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

  • @sivahariharan1231
    @sivahariharan1231 Год назад

    Thank u so much

  • @joshuamanampiu6489
    @joshuamanampiu6489 5 лет назад

    Excellent

  • @excelisfun
    @excelisfun 6 лет назад +1

    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 лет назад +1

      :) true. Happy Thanksgiving!

    • @excelisfun
      @excelisfun 6 лет назад +1

      Apple, Pumpkin and Pecan pie is okay today : )

    • @LeilaGharani
      @LeilaGharani  6 лет назад +1

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

    • @excelisfun
      @excelisfun 6 лет назад +1

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

    • @LeilaGharani
      @LeilaGharani  6 лет назад +2

      Good point! I should make my own :)

  • @abulhassanalbulushi6880
    @abulhassanalbulushi6880 4 года назад

    Excelente job!.. Thanks a lot

    • @LeilaGharani
      @LeilaGharani  4 года назад

      You're very welcome. Glad you like it.

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

    Very well explained...

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

    Thank you

  • @lawrencekazibwe9751
    @lawrencekazibwe9751 Год назад

    Thanks alot Leila

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

    Amazing video! Learnt a lot. Nice explanation.

  • @FaysalEasyExcel
    @FaysalEasyExcel 4 года назад

    you are awesome. thanks.

  • @Dev_Bartwal
    @Dev_Bartwal 6 лет назад

    Great class LG💕

  • @mahsaomrauni
    @mahsaomrauni 4 года назад

    you are the best teacher Leila

  • @Dichak2
    @Dichak2 Год назад

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

  • @lolilolita8502
    @lolilolita8502 5 лет назад

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

    • @LeilaGharani
      @LeilaGharani  5 лет назад

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

  • @samwoon1947
    @samwoon1947 6 лет назад

    Very useful. Thanks alot :)

  • @dillipaudel575
    @dillipaudel575 5 лет назад

    Thank Leila for this very useful video.

    • @LeilaGharani
      @LeilaGharani  5 лет назад

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

  • @tigereltoro
    @tigereltoro Год назад

    Awesome tutorial ! Thank you! :)

  • @apachespyder
    @apachespyder 4 года назад

    Very good video at a great pace. Thank you.

  • @bashinidulshara1943
    @bashinidulshara1943 Год назад

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

  • @louisa9516
    @louisa9516 4 года назад

    very easy to understand....thanks !!!!

    • @LeilaGharani
      @LeilaGharani  4 года назад

      You're very welcome. Glad you like it.