How to Build Dynamic Pivot Charts in Excel (with Dropdown Filters)

Want to toggle between region and consultant data in one chart? Here’s how to make dynamic Pivot Charts in Excel. 📬 Level up your spreadsheet skills (free newsletter): https://gotsheet.xyz/c/gotsheet-youtube This video walks you through the setup of a dynamic pivot chart in Excel using a dropdown selector, a helper column, and a pivot table. You'll learn to build a clean, interactive chart to switch between region-based and consultant-based revenue views. Bonus: we compare it to the Google Sheets version—and you might be surprised which works better. 🎬 Watch next: https://youtu.be/TvCIjjbY7Uk ──────────────────── 💰 Deals & Tools • Convert PDFs and images to Excel - https://lido.app/link/eamonn • Connect Google Sheets or Excel directly to your business systems like CRMs, databases, and APIs - https://coefficient.io/?via=eamonn • 20% off Beehiiv (3 mo.): https://beehiiv.com/partners/got-sheet?via=eamonn • My full tech stack: https://gotsheet.xyz/c/business-tech-stack • My recommended gear: https://amzn.to/4l47CyW *Disclosure: affiliate links may earn me a small commission at no cost to you.* ──────────────────── ⌚ Timestamps 00:00 Intro 00:09 What we’re building 00:31 Why filter views don’t work 01:00 Setup: group column + dropdown 01:40 Excel’s IF formula logic 02:56 Insert the pivot chart 03:32 Select table and build chart 04:00 Assign fields: group and revenue 04:37 Refresh issue in Excel 05:03 Chart type adjustments 05:27 Comparing Sheets vs Excel behavior 06:00 Final thoughts ──────────────────── 🌐 Site: https://eamonncottrell.com 📇 LinkedIn: https://linkedin.com/in/eamonncottrell 🐦 X/Twitter: https://twitter.com/EamonnCottrell