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

Рет қаралды 1,052,920

Күн бұрын

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 KZfaq ► • 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

Пікірлер: 345

@LeilaGharani 6 жыл бұрын

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 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 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 6 жыл бұрын

Doughnut chart

@LeilaGharani 6 жыл бұрын

Thanks Michael. That's a good suggestion :)

@LeilaGharani 6 жыл бұрын

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

@Mz_lady 3 жыл бұрын

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

@knowledgepeace4848 2 жыл бұрын

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.

@kushagarwal8953 5 жыл бұрын

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 4 жыл бұрын

you'd still not gonna get the bobs tho

@jmdd3162 5 жыл бұрын

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

@joshuateo8456 6 жыл бұрын

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 6 жыл бұрын

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

@catherinemaingi6767 5 жыл бұрын

thank you - very simply done and detailed.

@solsmacs.3552 5 жыл бұрын

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

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

@temirlanmukatay1765 4 жыл бұрын

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

@danielgheorghe2912 5 жыл бұрын

Good job! Thank you!

@KarenZappavignaHoogland 6 жыл бұрын

Thanks for this tutorial - very helpful information.

@shilpavaidya1077 5 жыл бұрын

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

@workinglivingtravellingini999 4 жыл бұрын

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

@ginotarabotto 5 жыл бұрын

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

@lifeofkiran6285 3 жыл бұрын

Same from 2021 thank you !!!!

@almiraviani Жыл бұрын

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

@brshankar2010 5 жыл бұрын

Good presentation, thanks for that.

@ricardoacevedo4811 2 жыл бұрын

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

@margaretdsouza3782 2 жыл бұрын

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

@ferozabuzar2805 4 жыл бұрын

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

@Sophia-nw2bk 3 жыл бұрын

Very well explained and easy to follow.

@valdannofernandes7984 2 жыл бұрын

You just make things so clear. Thanks.

@violetdeluxe 6 жыл бұрын

Hey nice job - thanks!

@abdullahibrahimjawad2648 6 жыл бұрын

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

@dipanjansaha1389 5 жыл бұрын

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

@marcuspo5211 5 жыл бұрын

thank you so much this is really helpful.

@aviadavraham77 3 жыл бұрын

SUPER USEFUL !! THANK YOU

@Sparqcorporatetraining Жыл бұрын

Outstanding, as always!

@jamesdowey6943 6 ай бұрын

Very well explained!! Thank you Jim

@Dhanesh87 Жыл бұрын

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

@kasiabarszczyk9970 Жыл бұрын

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

@administrativeassistant-co6985 3 жыл бұрын

Very well done, thank you.

@Anikvikram Жыл бұрын

Thank you Ma'am, its very helpful.

@DardouriNezha 5 жыл бұрын

Thank You Very Much!!!..

@anikchowdhury9708 Жыл бұрын

Thank you so much.

@Aricabacuto 4 жыл бұрын

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

@eltigrillopintito 2 жыл бұрын

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

@ZAHIDHUSSAIN-ri5kg 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

Glad you find it useful Zahid.

@jomar1202 3 жыл бұрын

very helpfull thank you

@peacetruth5243 Жыл бұрын

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

@meenakshivarshney1796 3 жыл бұрын

Thanks so much

@djchino774 Ай бұрын

Thank you!

@pavithradissanayaka6356 4 жыл бұрын

thanks so much for the video

@sunnyhu4855 5 жыл бұрын

I like this video. You are a good teacher.

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

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

@ckokse 5 жыл бұрын

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

@LeilaGharani 5 жыл бұрын

Thanks. I'm glad you like it :)

@aykutyldz1538 2 жыл бұрын

thank you very much for this fantastic tutorial

@vedavathivedavathi9045 4 жыл бұрын

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

@robertschneider9221 2 жыл бұрын

Thanks!

@uniquetamaaria1540 5 жыл бұрын

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

@FaysalEasyExcel 4 жыл бұрын

you are awesome. thanks.

@funnysun3291 5 жыл бұрын

thanks great one

@brandcutpiecehouse 4 жыл бұрын

Very informative and helpful video

@Pops113 2 жыл бұрын

You’re a legend thank you!!

@giorgidvali951159 Ай бұрын

I love all of your videos.

@lawrencekazibwe9751 Жыл бұрын

Thanks alot Leila

@KendraLock 4 жыл бұрын

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

@LeilaGharani 4 жыл бұрын

Glad it was helpful Kendra!

@sivahariharan1231 Жыл бұрын

Thank u so much

@hbfromkc 3 жыл бұрын

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 3 жыл бұрын

Glad it was helpful!

@clearconcept12 3 жыл бұрын

Very informative 👍

@bashinidulshara1943 Жыл бұрын

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

@dyaneespinosa8014 5 жыл бұрын

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

@LeilaGharani 5 жыл бұрын

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

@Drkalaamarab 4 жыл бұрын

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 .

@Simpletitbit123 10 ай бұрын

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

@AdiN5557 Жыл бұрын

Awesome..

@stephj765RS 4 жыл бұрын

Wow that's awesome. Crystal clear !

@LeilaGharani 4 жыл бұрын

Glad you like it.

@Dev_Bartwal 6 жыл бұрын

Great class LG💕

@LeilaGharani 6 жыл бұрын

Thanks Dev.

@mixme8655 6 жыл бұрын

Thank you very much Ms Leila

@LeilaGharani 6 жыл бұрын

You're very welcome.

@ahsanullahafridi9570 6 жыл бұрын

I love it as always.

@LeilaGharani 6 жыл бұрын

Thank you! Glad you like it.

@shahnawazshaikh1282 2 жыл бұрын

Very well explained...

@mahsaomrauni 4 жыл бұрын

you are the best teacher Leila

@umanggupta4769 3 жыл бұрын

Thank you

@juicesapfjori9370 3 жыл бұрын

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

@LeilaGharani 3 жыл бұрын

Glad you enjoyed it!

@douglaszulu6281 6 жыл бұрын

Great chart tools and insights Leila

@LeilaGharani 6 жыл бұрын

Thank you Douglas :) Looking forward to yours.

@joshuamanampiu6489 5 жыл бұрын

Excellent

@FranciscoVegagranmusica 5 жыл бұрын

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

@samwoon1947 6 жыл бұрын

Very useful. Thanks alot :)

@LeilaGharani 6 жыл бұрын

You're very welcome Sam.

@powerbiselfstudyguide Ай бұрын

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

@LeilaGharani Ай бұрын

Much appreciated!

@tigereltoro Жыл бұрын

Awesome tutorial ! Thank you! :)

@LeilaGharani Жыл бұрын

Glad you enjoyed it!

@riazhossain580 4 жыл бұрын

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

@LeilaGharani 4 жыл бұрын

You’re welcome 😊

@Dichak2 Жыл бұрын

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

@sunnyday8186 2 жыл бұрын

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

@LeilaGharani 2 жыл бұрын

Glad it was helpful, Anita!

@excelisfun 6 жыл бұрын

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 6 жыл бұрын

:) true. Happy Thanksgiving!

@excelisfun 6 жыл бұрын

Apple, Pumpkin and Pecan pie is okay today : )

@LeilaGharani 6 жыл бұрын

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

@excelisfun 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

Good point! I should make my own :)

@blackeagle336 Жыл бұрын

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

@LeilaGharani Жыл бұрын

You're very welcome!

@irviantantohaditomo8917 6 жыл бұрын

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

@LeilaGharani 6 жыл бұрын

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

@abulhassanalbulushi6880 5 жыл бұрын

Excelente job!.. Thanks a lot

@LeilaGharani 5 жыл бұрын

You're very welcome. Glad you like it.

@aberakifetew13 Жыл бұрын

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

@YogeshSharma-ee8ml 3 жыл бұрын

Thanks, you made simple things looks hard.

@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 6 жыл бұрын

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

@Faz527 3 жыл бұрын

Amazing video! Learnt a lot. Nice explanation.

@LeilaGharani 3 жыл бұрын

Glad to hear that!

@raghuv7114 4 жыл бұрын

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

@krishnaacharya4001 4 жыл бұрын

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 .

@dillipaudel575 5 жыл бұрын

Thank Leila for this very useful video.

@LeilaGharani 5 жыл бұрын

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

@JB-ty8mv 2 жыл бұрын

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

@LeilaGharani 2 жыл бұрын

I appreciate that!

@apachespyder 4 жыл бұрын

Very good video at a great pace. Thank you.

@LeilaGharani 4 жыл бұрын

Glad you liked it Sean!

@MikeyJLH 4 жыл бұрын

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 4 жыл бұрын

Glad you like the tutorials Michael.

@louisa9516 4 жыл бұрын

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

@LeilaGharani 4 жыл бұрын

You're very welcome. Glad you like it.

@henrikmanukyan3152 Жыл бұрын

<a href="#" class="seekto" data-time="640">10:40</a> well, now that's useful ! thanks)

@lxmoomum 6 жыл бұрын

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