In this video, you will learn how to create different types of charts in Microsoft Excel, such as column charts, bar charts, stacked column charts, and multiple columns charts. You will also learn how to insert a chart using the insert ribbon or the shortcut key Alt + F1. You will see how to add elements to your chart, such as titles, labels, legends, and gridlines. You will also learn how to format your chart, such as changing the colors, fonts, and styles. By the end of this video, you will be able to create professional-looking charts in Excel that can help you visualize and analyze your data.
📚 RESOURCES
- Workbook to follow along: 1drv.ms/x/s!Am...
- Alt + F1 to quickly insert a column chart
⌚ TIMESTAMPS
00:00 Introduction
00:21 Insert column chart
01:39 Change to bar chart
02:31 Bar chart vs. column chart
03:25 Shortcut to insert column chart
03:50 Add chart elements
04:50 Quick layouts
05:12 Change colors and styles
05:27 Add dynamic title
06:20 Multiple columns chart
07:53 Change colors
08:42 Adjust bar thickness and gap size
09:32 Stacked column chart
10:28 Wrap up
📺 RELATED VIDEOS
- 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...
🔽 CONNECT WITH ME
- Official website: www.kevinstratv...
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinSt...
- 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...
🙏 REQUEST VIDEOS
forms.gle/BDrT...
🔔 SUBSCRIBE ON RU-vid
www.youtube.co...
🙌 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 #excelcharts
18 авг 2024