Excel - Dynamiczny wykres na podstawie fragmentu tabeli przestawnej | Wyzwanie 45

In this 🎥video🎥, I present the solution to an Excel challenge given after the Excel "SuperHero" webinar, where we discussed PivotTables, Conditional Formatting, Formula Naming, and Lookup Functions. The webinar took place on September 14, 2023. If you would like to receive: 1. The webinar file 2. Link to the webinar recording 3. Reminder of the next workshop ★★★Sign up for our newsletter:★★★ https://exceliadam.pl/webinar-zapis 4. As a bonus, you'll receive 2.5 hours of recordings about PivotTables. The challenge involves creating a dynamic chart based only on a portion of the data from a PivotTable, which is selected based on values ​​from drop-down lists. In our solutions, we'll use: 📌 Pivot Tables 📌 Search Functions 📌 Formula Naming 📌 Dropdown lists and a few other essentials Files available for download at: https://exceliadam.pl/youtube in the Challenges folder --⏱️Timestamps⏱️-- 00:00 | Challenge Overview 00:58 | Preparing a Pivot Table 03:40 | Calculated Field Problem 04:40 | Show Values ​​as % and Ranking 07:03 | Chart Based on a TP Fragment 08:48 | Dropdown Lists 10:26 | Dynamic Range - OFFSET Function 15:21 | Formula Naming 18:43 | Dynamic Range - INDEX Function P.S. The Excel "SuperHero" webinar was a promotion for my course of the same name. My promotion has already expired 😥 but Udemy often runs promotions. Besides, I share a lot of videos 🎥🎥🎥 from the course publicly, so... https://www.udemy.com/course/excel-su... #Excel #exceliadam #ExcelSuperHero