Excel Charts and Graphs Tutorial

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

📩 NEWSLETTER

🔽 CONNECT WITH ME

🎒 MY COURSES

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

#stratvert #excel

[akibjaved]

How is this not having millions of views.

[lucianathomas]

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

[svymubq]

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

[techinventor]

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

[slyslickwickedaguilar]

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

[HamdanYouTuber]

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

[kingjulien]

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

[sidbowling]

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

[mer]

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

[IOSALive]

Kevin Stratvert, i love watching ur videos

[rvuwcmm]

Thank you, so simple and easy to understand

[BenRogersWPG]

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

[nguclaudia]

Thank you. Clear explanation and easy to understand. Just found myself a new excel tutor❤

[IOSALive]

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

[alio]

Kevin, Thank you very much that helped me with my report for Monday. You are the best

[gigidobbins]

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

[mphulom]

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

[rmkfhom]

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

[ramahdoori]

Kevin is a very good explainer. Thank you very much ..Though English is my 2nd Language, I can easily follow his speech and understand his explanations.

[fastrobreetus]

You are a genius and an excellent teacher!