Now that you know how to build a single, clean chart, it’s time to give it “brains.”
In the real world, people don’t just want to look at a static picture; they want to ask questions. “What about just the weekend sales?” or “How did Sarah perform compared to Mike?” Instead of building 50 different charts for every possible question, you are going to build one chart and add a Slicer. Think of a Slicer as a remote control for your data. When you click a button, the chart changes instantly.
What is a Slicer?
A Slicer is a visual filter. In the old days of Excel, you had to click a tiny arrow in a header, uncheck boxes, and click “OK.” It was slow and hidden.
A Slicer brings those filters out into the open as big, clickable buttons. It’s “user-friendly” because anyone—even your boss who hates technology—can understand how to click a button.
How to Add Your First Slicer
1. Select Your Chart
Click on the chart you created yesterday. You’ll notice a new tab appears at the top of your screen called PivotChart Analyze (Excel) or you’ll use the Filter menu (Google Sheets).
2. Insert the Slicer
Click the button that says Insert Slicer. A window will pop up showing you all the columns from your original data (e.g., Date, Region, Product, Salesperson).
3. Choose Your Category
Pick the category you want to “toggle” between.
- Example: If you pick “Region,” a box will appear on your screen with buttons for “East,” “West,” “North,” and “South.”
4. Click and Watch
Click on “East.” Your chart will instantly shrink or grow to show only the data for the East region. Click “West,” and it updates again. To see everything again, just click the “Clear Filter” icon (the little funnel with an X) in the top corner of the Slicer.
Connecting One Slicer to Multiple Charts
This is the “Pro” move. If you have a Bar Chart AND a Line Chart on the same page, you want them both to change when you click a button.
- Right-Click your Slicer.
- Select Report Connections.
- A list of all the Pivot Tables in your workbook will appear. Check the boxes for all of them.
- Hit OK.
Now, you have a synchronized dashboard. One click controls the entire story.
The “Golden Rules” for Slicers
| Rule | Why it Matters |
| Keep it Visible | Place Slicers on the left or top of your dashboard. People look there first. |
| Multi-Select | Hold the Ctrl key (or Cmd on Mac) to select two buttons at once (e.g., East AND West). |
| Style Matters | Match the color of your Slicer to the color of your charts so it looks like a professional “app.” |
Your 5-Minute Mission (Action Step)
- Open the file with your Fruit Chart (Apple/Orange).
- Add a column to your data called “Store” and label some rows “Store A” and some “Store B.”
- Refresh your Pivot Table.
- Insert a Slicer for “Store.”
- Click “Store A” and see how your Apple/Orange bars change.
Congratulations! You just built an interactive data tool.
Leave a Reply