Excel Charts and Graphs Tutorial

Рет қаралды 477,857

Күн бұрын

🔥 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 KZfaq
kzfaq.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

Пікірлер: 131

@KevinStratvert 11 ай бұрын

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: kzfaq.info/sun/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

@user-yk3en5cj6v 11 ай бұрын

Can you make video on all shortcut keys in excel?

@rebotilemasekela5982 2 ай бұрын

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

@sidbowling5944 Күн бұрын

Just wonderful in this day and age watching and listening to someone with a brain that functions correctly, you are an absolute credit to yourself, thank you !!!!!!!!!

@akibjaved07 10 ай бұрын

How is this not having millions of views.

@tawakalituabiodun1545 3 ай бұрын

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

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

@HamdanYouTuber 9 ай бұрын

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

@user-ys1by2qe8b 2 күн бұрын

Found this very Helpful! Thanks a lot

@mer2000100 4 ай бұрын

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

@kingjulien1934 11 ай бұрын

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

@user-sv9ym2ub7q 4 ай бұрын

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

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

@user-rm5kf4ho4m 6 күн бұрын

thanks a lot buddy you made my work easier keep it up your work good job.

@codyrogoff8985 8 ай бұрын

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

@slyslickwickedaguilar6002 10 күн бұрын

I found my new instructor! He explains everything with ease. Easy to understand!!!

@gigidobbins3135 4 ай бұрын

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

@rictravels 11 ай бұрын

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

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

@MdHadhi 5 ай бұрын

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

@jean5449 11 ай бұрын

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

@IOSALive 2 ай бұрын

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

@chipiturk90strend 45 минут бұрын

Re learning excel for good this time in order to get a better job. My current job did not appreciate or valued the improvements i did, instead they moved me to other minor team. Time to go! I know ill get the correct good job!

@TechWizz 9 ай бұрын

Thank you for this Kevin!

@karenm8948 11 ай бұрын

Thx!!! I needed this!

@IOSALive 3 ай бұрын

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

@user-rv5uw9cm2m Ай бұрын

Thank you ,so simple and easy to understand

@murators4732 11 ай бұрын

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

@BenRogersWPG 11 ай бұрын

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

@RedshiftDougal 11 ай бұрын

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

@c114 3 сағат бұрын

Thank you, much appreciated.

@mahinshah6665 21 күн бұрын

Loved it. Its a complete package. Thankyou

@mphulom 25 күн бұрын

This is the best excel tutorial video I have ever seen in KZfaq. You are the best!!!!

@jamesross5120 9 ай бұрын

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

@DaddyHexler 10 ай бұрын

Amazing, thank you.

@DigibrytDesign 11 ай бұрын

Thank for this video.

@txtzen 2 ай бұрын

you just saved my life, thanks so much!

@canirmalchoudhary8173 11 ай бұрын

This is good tutorial. Thank you😊

@icarussparks 5 ай бұрын

Damn thanks dude. You're my savior.

@user-sq5ek6fd1b 5 ай бұрын

thanks man really helpful

@josephbrolly7232 4 ай бұрын

You are too good Kevin. Great work

@lisathomasset3513 5 ай бұрын

Thanks for helping me!!

@fastrobreetus 16 күн бұрын

You are a genius and an excellent teacher!

@redshark903 11 ай бұрын

Nice man 👍, greetings from Poland 😁

@user-yk3en5cj6v 11 ай бұрын

Very informational video ❤️

@markrolandmabagos9575 8 ай бұрын

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

@khushibhatt5631 20 күн бұрын

Thank you so much u made so easy

@rymensymen1994 9 ай бұрын

This really helped!!

@mort4146 11 ай бұрын

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

@mort4146 11 ай бұрын

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

@muhammadbinuzair2101 2 ай бұрын

Thank you so much!!!

@mariamayo-salam6353 7 ай бұрын

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

@sandyramm6302 13 күн бұрын

Thanks!

@murleevijay428 11 ай бұрын

Thanks Kevin❤

@maryamomidi2120 10 ай бұрын

you are the best teacher

@dianafitzpatrick2423 2 ай бұрын

excellent - thank you

@sivareddy3745 2 ай бұрын

Hi Kevin this is good and nice explanation.

@deliathegreat 8 ай бұрын

Thanks kevin ❤

@sidratahir9627 3 ай бұрын

You are the best thank you

@tawakalituabiodun1545 3 ай бұрын

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

@mussiedebesay9870 Ай бұрын

thank you

@notfarfromgone1 8 ай бұрын

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

@musayabtahir1435 6 ай бұрын

Easy explained thanks Sir

@rafaelaraujo7127 9 ай бұрын

Thanks 💪

@MartaEden1 10 ай бұрын

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

@AlonCohen35 11 ай бұрын

Cavin, enjoying very much your videos

@charlesxix 11 ай бұрын

Kevin.

@MrK-ih3hr 11 ай бұрын

Thank you

@saiketpaul7460 6 ай бұрын

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

@motazramallah8504 8 ай бұрын

such wonderful video --wow

@learningwithmaliha 3 ай бұрын

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

@RoderickSpoke 7 ай бұрын

first class as ever Kevin

@LemonGoofball 4 ай бұрын

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

@andreausa123 4 ай бұрын

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

@bandaralqahtani4356 8 ай бұрын

you are my hero

@durgeshpratap185 11 ай бұрын

nice one

@ragulmarley4900 2 ай бұрын

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

@DogeLeague 9 ай бұрын

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 😅

@syclonusmusic 4 күн бұрын

Hello how can i make a performance chart to show for lets say a high performance car? things like fuel, zero to 60, top speed, battery power and road handling with turns or stopping?

@bmiller7017 11 ай бұрын

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

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

@mrprofessional2122 5 ай бұрын

Nice video bro

@KevinStratvert 5 ай бұрын

Thanks!

@DarasDish Ай бұрын

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

@nurtenbakc2562 7 ай бұрын

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

@geminicancer1163 9 ай бұрын

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?

@angelacalvin5790 7 ай бұрын

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.

@kathieturner 5 ай бұрын

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

@lyriczz801 12 күн бұрын

I thought i was a menace until i watched this video

@EuniceAikhatuamen 6 ай бұрын

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

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

@KevinStratvert 11 ай бұрын

We like forecasting. Gives the video some longevity 😂

@Pandoora0 11 ай бұрын

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

@NiXZi1 10 ай бұрын

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?

@clairebarton2794 7 ай бұрын

do you have interactive live classes?

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

How do you highlight non contingent data on mobile app?

@SIYAMAHMED-bm2bu 11 ай бұрын

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 ?

@techinventor2511 9 ай бұрын

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

Thank you❤

@BasseyBassey-xi8ht 2 ай бұрын

How do Creat multiple chart on one graph?

@FullersRoad 4 ай бұрын

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

@Lapploeffel 11 ай бұрын

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

@kaybobbitt7787 7 ай бұрын

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

@satyanishthaprana9308 11 ай бұрын

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

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

@stardommansion6773 4 ай бұрын

Line, pie, pivot

@roberttanner9522 7 ай бұрын

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.