Excel Pivot Chart with Slicers for Months to Show Values by Weekday Names 

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
This type of interactive chart is great for impressive dashboards. Quickly learn how to create an Excel Pivot chart that's driven by pivot slicers.
⬇️ Download the workbook here: pages.xelplus.com/weekday-sli...
🌟 What You'll Learn:
- Excel's Weekday Function: Understand how to use the Weekday function to identify weekdays corresponding to specific dates.
- Creating Pivot Charts: Learn the process of transforming raw data into meaningful pivot charts.
- Adding Slicers for Interactivity: Discover how to incorporate slicers for a dynamic data exploration experience.
📊 In This Tutorial:
- Data Preparation: Starting with a stock price dataset, we use the Weekday function to assign weekdays to dates.
- Custom Formatting: Convert weekday numbers to names using Excel's custom formatting features.
- Pivot Table Insights: Convert your data into a pivot table and then into a pivot chart for a visual representation of weekdays vs. average closing prices.
- Slicer Integration: Enhance your pivot chart with slicers to filter data by specific months or criteria.
- Design Tips: Get insights into adjusting chart styles and slicer formats for a professional look.
- Data Expansion: See how easily you can update your charts by adding new data to your Excel table.
💡 Pro Tips:
- Use the Weekday function for more than just identifying days; use it to discover trends and patterns.
- Leverage pivot charts and slicers to make your data presentations more interactive and informative.
In this example I cover two topics:
1. How to get Weekday name from a given date in Excel
2. How to create a Pivot Chart controlled by a Slicer
In addition I show you how you can customize slicers in Excel to better match your report layout.
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel