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
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
10 ай бұрын
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.
How is this not having millions of views.
@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 😂😂😂
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. 👏🏻👏🏻👏🏻👏🏻
Thank you ,so simple and easy to understand
I'm still trying to understand Excel, and your channel is one of the channels for learning Excel. Thank you for everything.
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! 🙂
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?
a basic, simple, almost rudiculous topic and - at the same time - one of the most needed tutorials ever :D
This is an AWESOME tutorial. It gave me great confidence to attempt my first chart.
Amazingly easy when it’s put in this format. Thank you 🙏🏻
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...
Kevin Your videos are the best you helped me by a lot keep making more videos like this one!
Just love it love it love it, thanks for making this video!! This made excel charts sooooo easy.
thanks for the information really needed a quick review as i haven't touched charts in years.
youve been a great help! thank you so much! watching from PH!
Thx!!! I needed this!
Thank you for this Kevin!
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❤❤❤
Kevin Stratvert, Subscribed because your videos are so much fun!
Kevin Stratvert, You're so talented! I had to hit the like button!
Man this is gold for dudes like me :D Thanks a million!
I love how all your recent video titles you can read in Borat's voice.
@RedshiftDougal
10 ай бұрын
Yes! I came here looking for this comment. Is production being farmed out to ChatGPT's EFL cousin?!
You are too good Kevin. Great work
you just saved my life, thanks so much!
love this presentation it will help to improve my report using chart
thanks man really helpful
This is good tutorial. Thank you😊
Nice man 👍, greetings from Poland 😁
Thank for this video.
Very informational video ❤️
Amazing, thank you.
Amazing work...I will have to relearn this chart again...
Nice Kevin!!! You are the best!❤❤
@mort4146
10 ай бұрын
I got a heart from Kevin, Sooooooo Happppppppy Todayyyyyyyyyyyy!😎😎
Damn thanks dude. You're my savior.
Thanks for helping me!!
Great Kevin and thank you ! Do you have video to show how to combine multiple excel tables together to use Pivot table ?
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 😅
Fn+Alt+F1 and Fn+F11 worked for me.
Thank you so much!!!
This really helped!!
excellent - thank you
Hi Kevin this is good and nice explanation.
Thanks Kevin❤
Kevin, Thank you so much for an amazing video on Excel Charts. Can you made a video on Waterfall Chart?
you are the best teacher
😭😭😭😭😭😭😭😭😭😭😭😭soooo sooo grateful for your efforts , for your videos, this was so helpfulllllll god bless you
I feel like i just graduated from excel chart university 🔥💪
New subscriber really kudos can u please upload video for actual target vs achieved target in different charts
Cavin, enjoying very much your videos
@charlesxix
10 ай бұрын
Kevin.
Easy explained thanks Sir
You are the best thank you
Thanks kevin ❤
thank you
Thank you
Kevin - universally accepted at any Thanksgiving dinner table. You rule. Gratitude.
such wonderful video --wow
first class as ever Kevin
Thanks 💪
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
10 ай бұрын
This is the latest version that comes with Microsoft 365. 👍
you are my hero
nice one
Thanks!
@KevinStratvert
6 ай бұрын
You bet!
11:21, Literally no option on Mac spent almost 30 minutes trying to figure it out. Any advice?
Nice video bro
@KevinStratvert
4 ай бұрын
Thanks!
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
5 ай бұрын
Thank you❤
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.
merhaba WB ve OECDden veri alındıktan sonra da excel üzeri grafik gösterebilir misiniz?
do you have interactive live classes?
Kevin- I am watching this with the dialog speech grey box covering the screen. How do I remove that please? ?
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?
Kelvin, please.. can you make a video for free and best resource to animate wallpapers? Like ambience or cozy videos on YT.. thank you ❤
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?
Already doing pre-sales for 2026 I see? The Kevin Cookie Company must really be taking off!
@KevinStratvert
10 ай бұрын
We like forecasting. Gives the video some longevity 😂
How do you highlight non contingent data on mobile app?
How do Creat multiple chart on one graph?
I need to use Fn + F1 or F11 to make the fast chart.
Line, pie, pivot
How is a data series defined? I know that there is a limitation of 255 data series, but what makes up 1 data series?
I have doubts while making excel graphs will u help me kindly?!
@eyes2338
2 ай бұрын
It's more for communicators with in a business.
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 ?
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?
👍
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
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
@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 ;)
What you do if excel doesn't recommend any charts
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.
can you do a charts for landlord to flow the rent
Your shortcut at 17:02 does not work on Mac
my excel doesn't make charts like this even though I do everything like you, I don't understand what is wrong
Do u know mariam nadiradze? she is working in microsoft…
🤗
umm what version of excel is this
@calandydesjardins9559
10 күн бұрын
Microsoft Excel 365
Hi kevin
Sorry quite confusing
The worse teacher of all time. Microsoft is doomed
All three of these suck, my college that would be helpful and it is not
Super, easy to underdtand, im from india
@kevinstratvert - Thank u so much - this was so well explained
Thank you