
# How to Connect Slicers with scattered plot on an Excel Dashboard (Beginner-Friendly Guide That Actually Works)
Introduction When building dashboards in Excel, one of the frustrating experiences is realizing that your slicers work perfectly with PivotTables, but your scattered charts refuse to respond correctly. You try clicking filters expecting your dashboard to behave interactively, but your scattered plots remain unchanged. One might even conclude that Excel is malfunctioning. But no, the Excel is functioning fine. I recently faced this challenge while building a dashboard for my Excel project. What looked like an issue turned out to reveal one of the most misunderstood concepts in Excel dashboards. Here is the good news. Once you understand how slicers , PivotTables , and Scattered charts work together, troubleshooting becomes very easy. In this guide, I’ll walk you step-by-step through connecting slicers to chart plots so your Excel dashboard becomes fully interactive. ⚠️The Problem When working on a dashboard project, most beginners naturally follow these steps: Cleaning the dataset and f
Continue reading on Dev.to
Opens in a new tab


