Excel Charts and Graphs Tutorial

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how to pull together charts in Excel. Charts are a great way to visualize and analyze your data, and Excel offers a variety of different chart types. You have line charts, pie charts, bar charts, pivot charts, and many more. In this video, we will cover the basics of creating, formatting, and modifying charts in Excel, as well as some tips and tricks to make your charts more effective.
📚 RESOURCES
- Sample workbook to follow along: 1drv.ms/x/s!AmxrofZZlZ-whaEnz...
- Alt + F1: Creates a new chart on the current worksheet
- F11: Creates a new chart on a new worksheet
⌚ TIMESTAMPS
00:00 Introduction
00:29 Insert chart
03:50 Modify chart selection
04:31 Avoid totals in charts
04:56 Select non-contiguous data
05:34 Change chart type
06:06 Chart shortcut keys
07:49 Chart titles
08:49 Chart elements
10:48 Styles and colors
11:09 Filter
11:32 Chart design tab
12:23 Chart format tab
12:53 Chart templates
14:03 Advanced options
15:52 Adjust position and size
16:44 Switch row and column
17:51 Sparklines
19:06 Pie charts
20:28 Pivot charts
23:55 Wrap up
📺 RELATED VIDEOS
- How to Create Pivot Table in Excel: • How to Create Pivot Ta...
- Playlist with all my videos on Excel: • ❎ How to use Excel
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON KZbin
kzbin.info?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
#stratvert #excel

[@KevinStratvert]

Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: kevinstratvert.thinkific.com/ ⏭ Watch Next - Playlist with all my free Excel tutorials: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

[@user-yk3en5cj6v]

Can you make video on all shortcut keys in excel?

[@rebotilemasekela5982]

Thank you. I am preparing this for a job 😅 Hope I will be able to retain and remember everything within a week.

[@akibjaved07]

How is this not having millions of views.

[@tawakalituabiodun1545]

Oh cause is not for everyone is for people that want to learn and also this is not a laugh content is for Jobs that is making cool cash out there if you know you know 😂😂😂

[@user-sv9ym2ub7q]

Thank you soooo much! I urgently needed to create a chart for my husband, and have not done anything like this in many years! With your guidance today I was able to do so! Very good video!!

[@michaeldonne561]

Is he doing his chores more efficiently now with the chart?

[@lucianathomas8722]

You have the best Excel tutorials on KZbin! Thank you so much for making it seem so simple and for explaining it so well! So glad I found your videos. 👏🏻👏🏻👏🏻👏🏻

[@BenRogersWPG]

I love how all your recent video titles you can read in Borat's voice.

[@RedshiftDougal]

Yes! I came here looking for this comment. Is production being farmed out to ChatGPT's EFL cousin?!

[@HamdanYouTuber]

I'm still trying to understand Excel, and your channel is one of the channels for learning Excel. Thank you for everything.

[@kingjulien1934]

a basic, simple, almost rudiculous topic and - at the same time - one of the most needed tutorials ever :D

[@mer2000100]

Kevin, I can’t thank you enough for your videos! You have helped me so many times get through work projects when I was struggling and didn’t know where to turn for help. You’re an excellent teacher and I’m so glad I found you! 🙂

[@gigidobbins3135]

This is an AWESOME tutorial. It gave me great confidence to attempt my first chart.

[@codyrogoff8985]

Amazingly easy when it’s put in this format. Thank you 🙏🏻

[@rictravels]

Hi Kevin, loves your videos.... Simple yet high quality.... You are a great inspiration... Am starting my own & hope to be as successful as you... Take Care...

[@footballskillschannel5948]

Kevin Your videos are the best you helped me by a lot keep making more videos like this one!

[@notfarfromgone1]

Kevin - universally accepted at any Thanksgiving dinner table. You rule. Gratitude.

[@jean5449]

youve been a great help! thank you so much! watching from PH!

[@MdHadhi]

Just love it love it love it, thanks for making this video!! This made excel charts sooooo easy.

[@IOSALive]

Kevin Stratvert, You're so talented! I had to hit the like button!

[@MartaEden1]

Fn+Alt+F1 and Fn+F11 worked for me.

[@IOSALive]

Kevin Stratvert, Subscribed because your videos are so much fun!

[@muhammadbinuzair2101]

Thank you so much!!!

[@jamesross5120]

thanks for the information really needed a quick review as i haven't touched charts in years.

[@txtzen]

you just saved my life, thanks so much!

[@user-sq5ek6fd1b]

thanks man really helpful

[@tawakalituabiodun1545]

Greetings to you, I love your teachings, I have an assignment which will be recorded as part of my exam marks, then I came to search how to go about it, cause I was taught basis in the class and I got confused but now I watched the class, just the highlighted part and am good to go. I come back to learn more love you❤❤❤

[@josephbrolly7232]

You are too good Kevin. Great work

[@TechWizz]

Thank you for this Kevin!

[@dianafitzpatrick2423]

excellent - thank you

[@canirmalchoudhary8173]

This is good tutorial. Thank you😊

[@user-yk3en5cj6v]

Very informational video ❤️

[@redshark903]

Nice man 👍, greetings from Poland 😁

[@icarussparks]

Damn thanks dude. You're my savior.

[@murators4732]

Man this is gold for dudes like me :D Thanks a million!

[@markrolandmabagos9575]

love this presentation it will help to improve my report using chart

[@murleevijay428]

Thanks Kevin❤

[@saiketpaul7460]

😭😭😭😭😭😭😭😭😭😭😭😭soooo sooo grateful for your efforts , for your videos, this was so helpfulllllll god bless you

[@mariamayo-salam6353]

Amazing work...I will have to relearn this chart again...

[@karenm8948]

Thx!!! I needed this!

[@mort4146]

Nice Kevin!!! You are the best!❤❤

[@mort4146]

I got a heart from Kevin, Sooooooo Happppppppy Todayyyyyyyyyyyy!😎😎

[@DaddyHexler]

Amazing, thank you.

[@AlonCohen35]

Cavin, enjoying very much your videos

[@charlesxix]

Kevin.

[@lisathomasset3513]

Thanks for helping me!!

[@sivareddy3745]

Hi Kevin this is good and nice explanation.

[@DigibrytDesign]

Thank for this video.

[@learningwithmaliha]

Kevin, Thank you so much for an amazing video on Excel Charts. Can you made a video on Waterfall Chart?

[@maryamomidi2120]

you are the best teacher

[@andreausa123]

Great Kevin and thank you ! Do you have video to show how to combine multiple excel tables together to use Pivot table ？

[@LemonGoofball]

11:21, Literally no option on Mac spent almost 30 minutes trying to figure it out. Any advice?

[@mussiedebesay9870]

thank you

[@musayabtahir1435]

Easy explained thanks Sir

[@DogeLeague]

Hey Kevin, love this video. Is there any chance at all you can make a video with tips on how to be an effective Program Manager (PM)? I ask because I was recently promoted to this role and I am having a bit of trouble adapting in this area 😅

[@deliathegreat]

Thanks kevin ❤

[@ragulmarley4900]

New subscriber really kudos can u please upload video for actual target vs achieved target in different charts

[@techinventor2511]

00:06 Learn how to make a chart in Excel and analyze your data 02:37 Excel offers over 17 different types of charts with various variations. 04:49 You can select different periods of data to showcase on a chart. 07:08 Creating and modifying line charts in Excel. 09:25 Adding axis titles and a trend line to a chart 11:36 Excel charts and graphs can be customized in various ways. 13:44 You can modify chart templates and adjust specific elements to customize the appearance. 15:57 You can move and adjust the size of your chart by clicking and dragging 18:17 Excel Charts and Graphs Tutorial: Creating Sparklines and Pie Charts 20:24 Pivot charts in Excel are a powerful way to create charts 22:42 Excel charts and graphs can be easily created to visualize data in different views

[@michaelampofo7656]

Thank you❤

[@Anshu_0.7]

Thank you

[@RoderickSpoke]

first class as ever Kevin

[@sidratahir9627]

You are the best thank you

[@rymensymen1994]

This really helped!!

[@BBKing1977]

Already doing pre-sales for 2026 I see? The Kevin Cookie Company must really be taking off!

[@KevinStratvert]

We like forecasting. Gives the video some longevity 😂

[@motazramallah8504]

such wonderful video --wow

[@kathieturner]

Kevin- I am watching this with the dialog speech grey box covering the screen. How do I remove that please? ?

[@bmiller7017]

Always appreciate your videos. Can you tell us which version of Excel you are using? I see funnel as an option, I don't have that on my version (eek... 2016).

[@KevinStratvert]

This is the latest version that comes with Microsoft 365. 👍

[@durgeshpratap185]

nice one

[@nurtenbakc2562]

merhaba WB ve OECDden veri alındıktan sonra da excel üzeri grafik gösterebilir misiniz?

[@mrprofessional2122]

Nice video bro

[@KevinStratvert]

Thanks!

[@stardommansion6773]

Line, pie, pivot

[@Bessie-On-Wheels]

How do you highlight non contingent data on mobile app?

[@bandaralqahtani4356]

you are my hero

[@mgeckerdt]

Thanks!

[@KevinStratvert]

You bet!

[@rafaelaraujo7127]

Thanks 💪

[@geminicancer1163]

I would like to make a pie chart in Excel adding all the same descriptions and the total of those descriptions and cost. So it would show up in the pie chart the total cost for each descriptions for that month and not each description. How to I go about that?

[@vidyasagar-kw6qb]

I have doubts while making excel graphs will u help me kindly?!

[@eyes2338]

It's more for communicators with in a business.

[@angelacalvin5790]

I tried to follow along but I didn't get alot of the pop up selections that you did like chart elements on the side. SO I wasn't sure where to find this info. I am also working in a mac.

[@FullersRoad]

How is a data series defined? I know that there is a limitation of 255 data series, but what makes up 1 data series?

[@BasseyBassey-xi8ht]

How do Creat multiple chart on one graph?

[@EuniceAikhatuamen]

I need help with Microsoft Excel. I'm not able to change the Horizontal Axis on the Data Chart. Can you show me the updated way to do that, please?

[@clairebarton2794]

do you have interactive live classes?

[@NiXZi1]

I do not get the the squares on the top left corner of my diagram (The green cross, the paintbrush and the funnel). Someone got a tip?

[@Pandoora0]

Kelvin, please.. can you make a video for free and best resource to animate wallpapers? Like ambience or cozy videos on YT.. thank you ❤

[@kaybobbitt7787]

I need to use Fn + F1 or F11 to make the fast chart.

[@Lapploeffel]

@KevinStratvert Hey Kevin i have a really big Issue with my data on my Bachelor Thesis. The Problem: i have 5*2 data rows in which the 2 always belong together. Now i want to make the average from both, but at the same time i want to have the error Indicators from both original lines around the average line without seeing 3 lines. So i could just build the average data row but than i don't get the error indicator for the original data rows. Another idea was to use a trend line between the both data rows (is this possible?) an than doing an error indicator of the trendline (is this possible?) and than hiding the orginal data row lines and just showing the trend line with error indicators? would be really glad if anyone can help me ;) have a nice day everyone ;)

[@SIYAMAHMED-bm2bu]

My Windows 11 TaskBar Size are not smalling. I Have Tried Resetting File Explorer Many Times, But Still It's Not Working. How To Fix It ?

[@FoxyCS_]

my excel doesn't make charts like this even though I do everything like you, I don't understand what is wrong

[@ptjones3463]

Your shortcut at 17:02 does not work on Mac

[@danielmoorhead5103]

What you do if excel doesn't recommend any charts

[@mimioved12]

can you do a charts for landlord to flow the rent

[@satyanishthaprana9308]

My Bluetooth and wifi keep disappearing in windows 11 . I have searched for remedies on Google.Nothing seems to work. Can you please make a video and show troubleshooting for the same

[@bogmire9608]

Is there any way to make a chart WITHOUT these shortcuts? Meaning you put data into the graph as you are making it? It seems that no one online knows

[@roberttanner9522]

What if I have a worksheet with two tables. 1 for year A and say 7 types of cookies and how many sold and by month and a second table for year B. if I wanted to chart say cookie type 2 and 6 for years A and B how can you easily do that. I tried highlighting just the data, didn't work. I tried a couple other things, didn't work. I was able to build the chart but it took WAY longer than it should in 2023. I know there's gotta be an easier way.

[@XLLearner_Courses]

👍

[@topminer1451]

Do u know mariam nadiradze? she is working in microsoft…

[@cstpa1]

umm what version of excel is this

[@calandydesjardins9559]

Microsoft Excel 365

[@davidjamgochian]

🤗

[@SelfLearning01-me2qx]

Hi kevin

[@emrandafadar4445]

Sorry quite confusing

[@silassoule5077]

The worse teacher of all time. Microsoft is doomed

[@nancyjackson9924]

All three of these suck, my college that would be helpful and it is not

[@rameshhariharan2623]

Super, easy to underdtand, im from india

[@helendroza3833]

@kevinstratvert - Thank u so much - this was so well explained

[@MrK-ih3hr]

Thank you