Excel Charts & Graphs: Learn the Basics for a Quick Start
VloĆŸit
- Äas pĆidĂĄn 30. 06. 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 CZcams âș âą 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
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.
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.
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
Doughnut chart
Thanks Michael. That's a good suggestion :)
Hi JP - Pie charts are not as easy to read as sorted bar / column charts. Check out this video for more info: czcams.com/video/xO_lCIAlnV0/video.html
This is the best chart tutorial I've found! Quick, to the point, easy to understand :) And you taught some nice shortcuts!
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.
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 !!
you'd still not gonna get the bobs tho
as usual this has been a very good video leila, thanks a lot!
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.
Thank you very much Thomas for your support and the kind words.
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!!!
A very very nice explanation, calmly and precise ... especially for those who speak English like a second language.
First video I have watched, it has helped me to understand some very basics I never really understood before. Thanks!
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
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 .
Super easy to follow. thank you for your time in this.
thank you - very simply done and detailed.
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.
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!
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.
Glad you like the tutorials Michael.
The Best Tutorial on CZcams on Excel Charts Basics. This is point to point video and cover all important aspects as well. Keep it up!
Much appreciated!
Thank you Leila. Well explained and very useful. Stay Blessed!
Thanks very much Leila for the great job...! i am learning so much from you
You're an awesome tutor, thank you! And happy 2019.
Same from 2021 thank you !!!!
such a brilliant tutorial! thank you for your time & effort!
Thank you!!!Your videos are really helpful.Continue that way
All your videos are really helpful and I have a new found appreciation for excel :)
Very helpful, lots of extra tips that other tutorials don't mention, thank you!
Thank you Leila this video was very informative, short and helpful.
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 : )
:) true. Happy Thanksgiving!
Apple, Pumpkin and Pecan pie is okay today : )
Yum! I remember in Canada they had the best Pecan pies....unfortunately nothing like it here in Austria.....
You can get one in Excel with the =PECANPIEINAUSTRIA() Function !!!!
Good point! I should make my own :)
Thanks for this tutorial - very helpful information.
thank you for getting to the point!!! i was having a hard time and literally understood how to add a chart within one minute!
Glad it was helpful!
You just make things so clear. Thanks.
Leila The videos are very useful and to the point! Thank you
Thanks Leila. It took me ages to find how to stop excel from grouping items in a dataset.
Very well explained and easy to follow.
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
I'm glad you find the tips useful Darren - yes- usually time constraints don't go hand-in-hand with nice charts :)
Thank you so much :) Very easy to follow. My first chart is done! Yey!!!
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
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 :)
Guruji, It shows your greatness!!!!!!!!!! once again a big salute.
Just to say you Leila that I am your Fan and your student number one, thanks to teach Excel
Very well explained!!
Thank you
Jim
I really like this video. I know understood properly and thank you so much for doing this video đđâș
Thank you Ma'am, its very helpful.
Many, Many Thanks Leila! it was wonderful. Thanks for sharing.
Glad you find it useful Zahid.
Good presentation, thanks for that.
As always simple and to the point. You are the best!
Thanks. I'm glad you like it :)
it's Well received.Now my target is on excell charts to understand completely and to learn within a week.
This was really well done to explain to me the basics of charts, ty kindly.
I'm going to subscribe to channel now. It's informative and more detailed unlike the others I have watched so far.
Good job! Thank you!
Thank you so much Leila. This is really easy to understand for a beginner like me.
Youâre welcome đ
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
thanks Leila for the basic feature chart explanationđ
You're welcome đ
Excellent! Thanks very much for the video....
I think this is a great training video for beginners like me! Thank you!
Thank you! I'm glad you find it helpful :)
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 .
I like your tutorials. It is explained in a very simple language. keep it up.
really good, so clear and instructive even 5 years later!! thank you!
You're very welcome!
thank you so much this is really helpful.
SUPER USEFUL !! THANK YOU
Outstanding, as always!
So awesome to learn all this. TY so much and the best for you
Thanks so much! This video is so good and helpful. You explanation always make things easy to understand.
Glad it was helpful, Anita!
Awesome video. Easy to understand. Very helpful. Thank you.
Glad it was helpful Kendra!
I like this video. You are a good teacher.
Hey nice job - thanks!
I am impressed with your content and teaching style. Excellent!!
I appreciate that!
Thank you very much! This was very thorough and helpful.
Glad you enjoyed it!
Very well done, thank you.
Your teaching is very Clean and clear and next level .
Glad to hear that!
Thank You Very Much!!!..
thank you very much for this fantastic tutorial
Leila Gharani
Very good presentation
BEST REGARDS
Wow that's awesome. Crystal clear !
Glad you like it.
At first I was distracted lol but I caught up very fast . Thanks Leila topics well presented
Great chart tools and insights Leila
Thank you Douglas :) Looking forward to yours.
I love all of your videos.
Too many good information đhaha
Not complaining just enjoyed it. Thank you đđż
Thank you!
Thank you very much Ms Leila
You're very welcome.
Thank you so much.
Good videos. I can improving my skills. Thank you.
You're very welcome! I'm glad to hear that.
hello new to this I think this will help me understand Excel a lot more. I haven't done this for a long time
Dear Leila,
I have found this video very useful and professional. Your way of teaching is excellent and it shows that you have worked very hard to make the script of the video and how to present it. Really good source of learning. I have best wishes for you to grow ameen.
Best regards,
Muhammad Ali Awan
You are welcome and Thank you!
Thanks, you made simple things looks hard.
Great class LGđ
Thanks Dev.
Very informative and helpful video
you are the best teacher Leila
very helpful thanks
Very good presentation. I love the way you teach it.
I'm glad you like the teaching! Thank you.
Very informative đ
Thanks so much
Amazing video! Learnt a lot. Nice explanation.
Glad to hear that!
thanks so much for the video
really it is very good explanation and very easy to learn.
very nice effort. it is much useful for my work. thanks a lot dear Leila Gharani . stay blessed. i am from lahore, pakistan.
You're very welcome. I'm happy to hear this helps for your work! Thank you for your support.
Very good video at a great pace. Thank you.
Glad you liked it Sean!
Youâre a legend thank you!!
Thnk u so much , it's valuble vedio , again tnx đ
Thanks for the video, I loath excel (prefer SPSS) but I have to use it for this assignment.
Thank u so much Ms. Leila it was really really useful and I've learned a lot from it waiting the next video hhh
You're very welcome Ismail.
by the way happy thanksgiving
Thank Leila for this very useful video.
My pleasure. I'm glad it's useful.
Very well explained...
Very helpful as always! I have a problem I am hoping you can help with. Iâve watched many of your videos but havenât found one that shows how to have a Grand Total to appear on a chart. Itâs on the table, and I can get totals for each column- but I need a total of the amount of all bars in one. Any suggestions?
I love it as always.
Thank you! Glad you like it.