🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
Pivot charts are a powerful way to visualize and analyze data in Excel. They allow you to summarize and compare large amounts of data in different ways, such as by categories, regions, or time periods. In this video, you will learn how to create and customize pivot charts in Excel, from formatting the data to changing the chart type.
You will learn how to:
- Format the data in columns so that it can be used for pivot charts
- Insert a pivot chart using the Insert tab
- Understand what fields are and how to drag them into the areas to start constructing a pivot chart
- Change the chart type
- Apply filters to the pivot chart to refine the data
By the end of this video, you will have a strong grasp of how pivot charts work and how to use them to create dynamic and interactive charts in Excel. You will also be able to apply the same skills to create pivot tables, which are another way to summarize and analyze data in Excel.
📚 RESOURCES
- Sample workbook to follow along: 1drv.ms/x/s!AmxrofZZlZ-wha0FbNIDuh_BHhEgVw?e=WyNc0e
- Pivot Tables tutorial: youtu.be/PdJzy956wo4
- In-depth Excel Charts tutorial: youtu.be/eHtZrIb0oWY
⌚ TIMESTAMPS
00:00 Introduction
00:21 Prepare data
00:53 Insert pivot chart
01:29 PivotChart fields
02:03 Drag fields between areas
04:40 Change chart type
05:52 Design and format
06:41 Filter field
07:23 Insert new pivot chart
08:13 Switch row and column
09:29 Filters area
10:50 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: youtube.com/playlist?list=PLlKpQrBME6xLDnoK7OovAVVsGNV55MS3K
📩 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 website: kevinstratvert.com
- LinkedIn: linkedin.com/in/kevinstratvert/
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/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 YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
🙌 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 #pivotcharts
- How to Make Pivot Chart in Excel ( Download)
- MS Excel - Pivot Chart ( Download)
- How to create pivot charts in Excel ( Download)
- Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1) ( Download)
- Take Your Pivot Charts to the Next Level - Expert Tips ( Download)
- Pivot Table Excel Tutorial ( Download)
- How to Create Excel Pivot Tables & Pivot Charts - Beginner's Guide ( Download)
- How to Create Pivot Table in Excel ( Download)
- How to Create a Pivot Chart in Excel 2016 ( Download)
- Create Pivot Charts in Microsoft Excel ( Download)
- How to create a Pivot Table in Excel ( Download)
- EASY Excel Pivot Charts ( Download)
- Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!) ( Download)
- How to create Pivot Chart from Pivot Table ( Download)
- Pivot Charts Tutorial: Microsoft Excel Tutorial ( Download)
