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 KZread
kzread.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

Пікірлер: 115

  • @KevinStratvert
    @KevinStratvert10 ай бұрын

    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: kzread.info/head/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

  • @user-yk3en5cj6v

    @user-yk3en5cj6v

    10 ай бұрын

    Can you make video on all shortcut keys in excel?

  • @rebotilemasekela5982

    @rebotilemasekela5982

    Ай бұрын

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

  • @akibjaved07
    @akibjaved079 ай бұрын

    How is this not having millions of views.

  • @tawakalituabiodun1545

    @tawakalituabiodun1545

    2 ай бұрын

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

  • @lucianathomas8722
    @lucianathomas872210 ай бұрын

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

  • @user-rv5uw9cm2m
    @user-rv5uw9cm2m2 күн бұрын

    Thank you ,so simple and easy to understand

  • @HamdanYouTuber
    @HamdanYouTuber8 ай бұрын

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

  • @mer2000100
    @mer20001003 ай бұрын

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

  • @user-sv9ym2ub7q
    @user-sv9ym2ub7q3 ай бұрын

    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

    @michaeldonne561

    Ай бұрын

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

  • @kingjulien1934
    @kingjulien193410 ай бұрын

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

  • @gigidobbins3135
    @gigidobbins31353 ай бұрын

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

  • @codyrogoff8985
    @codyrogoff89857 ай бұрын

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

  • @rictravels
    @rictravels10 ай бұрын

    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
    @footballskillschannel59489 ай бұрын

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

  • @MdHadhi
    @MdHadhi4 ай бұрын

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

  • @jamesross5120
    @jamesross51207 ай бұрын

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

  • @jean5449
    @jean544910 ай бұрын

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

  • @karenm8948
    @karenm894810 ай бұрын

    Thx!!! I needed this!

  • @TechWizz
    @TechWizz8 ай бұрын

    Thank you for this Kevin!

  • @tawakalituabiodun1545
    @tawakalituabiodun15452 ай бұрын

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

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

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

  • @IOSALive
    @IOSALive2 ай бұрын

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

  • @murators4732
    @murators473210 ай бұрын

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

  • @BenRogersWPG
    @BenRogersWPG10 ай бұрын

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

  • @RedshiftDougal

    @RedshiftDougal

    10 ай бұрын

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

  • @josephbrolly7232
    @josephbrolly72323 ай бұрын

    You are too good Kevin. Great work

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

    you just saved my life, thanks so much!

  • @markrolandmabagos9575
    @markrolandmabagos95757 ай бұрын

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

  • @user-sq5ek6fd1b
    @user-sq5ek6fd1b4 ай бұрын

    thanks man really helpful

  • @canirmalchoudhary8173
    @canirmalchoudhary817310 ай бұрын

    This is good tutorial. Thank you😊

  • @redshark903
    @redshark90310 ай бұрын

    Nice man 👍, greetings from Poland 😁

  • @DigibrytDesign
    @DigibrytDesign10 ай бұрын

    Thank for this video.

  • @user-yk3en5cj6v
    @user-yk3en5cj6v10 ай бұрын

    Very informational video ❤️

  • @DaddyHexler
    @DaddyHexler9 ай бұрын

    Amazing, thank you.

  • @mariamayo-salam6353
    @mariamayo-salam63536 ай бұрын

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

  • @mort4146
    @mort414610 ай бұрын

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

  • @mort4146

    @mort4146

    10 ай бұрын

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

  • @icarussparks
    @icarussparks4 ай бұрын

    Damn thanks dude. You're my savior.

  • @lisathomasset3513
    @lisathomasset35134 ай бұрын

    Thanks for helping me!!

  • @andreausa123
    @andreausa1233 ай бұрын

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

  • @DogeLeague
    @DogeLeague8 ай бұрын

    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 😅

  • @MartaEden1
    @MartaEden19 ай бұрын

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

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

    Thank you so much!!!

  • @rymensymen1994
    @rymensymen19948 ай бұрын

    This really helped!!

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

    excellent - thank you

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

    Hi Kevin this is good and nice explanation.

  • @murleevijay428
    @murleevijay42810 ай бұрын

    Thanks Kevin❤

  • @learningwithmaliha
    @learningwithmaliha2 ай бұрын

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

  • @maryamomidi2120
    @maryamomidi21209 ай бұрын

    you are the best teacher

  • @saiketpaul7460
    @saiketpaul74605 ай бұрын

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

  • @DarasDish
    @DarasDishКүн бұрын

    I feel like i just graduated from excel chart university 🔥💪

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

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

  • @AlonCohen35
    @AlonCohen3510 ай бұрын

    Cavin, enjoying very much your videos

  • @charlesxix

    @charlesxix

    10 ай бұрын

    Kevin.

  • @musayabtahir1435
    @musayabtahir14355 ай бұрын

    Easy explained thanks Sir

  • @sidratahir9627
    @sidratahir96272 ай бұрын

    You are the best thank you

  • @deliathegreat
    @deliathegreat6 ай бұрын

    Thanks kevin ❤

  • @mussiedebesay9870
    @mussiedebesay987012 күн бұрын

    thank you

  • @MrK-ih3hr
    @MrK-ih3hr10 ай бұрын

    Thank you

  • @notfarfromgone1
    @notfarfromgone17 ай бұрын

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

  • @motazramallah8504
    @motazramallah85047 ай бұрын

    such wonderful video --wow

  • @RoderickSpoke
    @RoderickSpoke6 ай бұрын

    first class as ever Kevin

  • @rafaelaraujo7127
    @rafaelaraujo71278 ай бұрын

    Thanks 💪

  • @bmiller7017
    @bmiller701710 ай бұрын

    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

    @KevinStratvert

    10 ай бұрын

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

  • @bandaralqahtani4356
    @bandaralqahtani43567 ай бұрын

    you are my hero

  • @durgeshpratap185
    @durgeshpratap18510 ай бұрын

    nice one

  • @mgeckerdt
    @mgeckerdt6 ай бұрын

    Thanks!

  • @KevinStratvert

    @KevinStratvert

    6 ай бұрын

    You bet!

  • @LemonGoofball
    @LemonGoofball2 ай бұрын

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

  • @mrprofessional2122
    @mrprofessional21224 ай бұрын

    Nice video bro

  • @KevinStratvert

    @KevinStratvert

    4 ай бұрын

    Thanks!

  • @techinventor2511
    @techinventor25117 ай бұрын

    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

    @michaelampofo7656

    5 ай бұрын

    Thank you❤

  • @angelacalvin5790
    @angelacalvin57906 ай бұрын

    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.

  • @nurtenbakc2562
    @nurtenbakc25626 ай бұрын

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

  • @clairebarton2794
    @clairebarton27946 ай бұрын

    do you have interactive live classes?

  • @kathieturner
    @kathieturner4 ай бұрын

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

  • @geminicancer1163
    @geminicancer11637 ай бұрын

    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?

  • @Pandoora0
    @Pandoora010 ай бұрын

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

  • @EuniceAikhatuamen
    @EuniceAikhatuamen5 ай бұрын

    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?

  • @BBKing1977
    @BBKing197710 ай бұрын

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

  • @KevinStratvert

    @KevinStratvert

    10 ай бұрын

    We like forecasting. Gives the video some longevity 😂

  • @Bessie-On-Wheels
    @Bessie-On-Wheels3 ай бұрын

    How do you highlight non contingent data on mobile app?

  • @BasseyBassey-xi8ht
    @BasseyBassey-xi8ht29 күн бұрын

    How do Creat multiple chart on one graph?

  • @kaybobbitt7787
    @kaybobbitt77876 ай бұрын

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

  • @stardommansion6773
    @stardommansion67733 ай бұрын

    Line, pie, pivot

  • @FullersRoad
    @FullersRoad3 ай бұрын

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

  • @vidyasagar-kw6qb
    @vidyasagar-kw6qb4 ай бұрын

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

  • @eyes2338

    @eyes2338

    2 ай бұрын

    It's more for communicators with in a business.

  • @SIYAMAHMED-bm2bu
    @SIYAMAHMED-bm2bu10 ай бұрын

    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 ?

  • @NiXZi1
    @NiXZi18 ай бұрын

    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?

  • @XLLearner_Courses
    @XLLearner_Courses7 ай бұрын

    👍

  • @bogmire9608
    @bogmire96087 ай бұрын

    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

  • @satyanishthaprana9308
    @satyanishthaprana930810 ай бұрын

    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

  • @Lapploeffel
    @Lapploeffel10 ай бұрын

    @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 ;)

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

    What you do if excel doesn't recommend any charts

  • @roberttanner9522
    @roberttanner95226 ай бұрын

    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.

  • @mimioved12
    @mimioved124 ай бұрын

    can you do a charts for landlord to flow the rent

  • @ptjones3463
    @ptjones34636 ай бұрын

    Your shortcut at 17:02 does not work on Mac

  • @FoxyCS_
    @FoxyCS_13 күн бұрын

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

  • @topminer1451
    @topminer145110 ай бұрын

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

  • @davidjamgochian
    @davidjamgochian10 ай бұрын

    🤗

  • @cstpa1
    @cstpa116 күн бұрын

    umm what version of excel is this

  • @calandydesjardins9559

    @calandydesjardins9559

    10 күн бұрын

    Microsoft Excel 365

  • @SelfLearning01-me2qx
    @SelfLearning01-me2qx2 ай бұрын

    Hi kevin

  • @emrandafadar4445
    @emrandafadar44453 ай бұрын

    Sorry quite confusing

  • @silassoule5077
    @silassoule507710 ай бұрын

    The worse teacher of all time. Microsoft is doomed

  • @nancyjackson9924
    @nancyjackson99247 ай бұрын

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

  • @rameshhariharan2623
    @rameshhariharan262310 ай бұрын

    Super, easy to underdtand, im from india

  • @helendroza3833
    @helendroza38337 ай бұрын

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

  • @Anshu_0.7
    @Anshu_0.75 ай бұрын

    Thank you

Келесі