How to Make an Interactive Dashboard in Excel (Cross-Filtering)
You want to click a chart and watch every other chart filter to match — but in Excel that means wiring slicers across PivotCharts, and it's still not true cross-filtering. Here's the one-click way to get Power BI-style behaviour.
Last updated: August 2026
| Your table | Live dashboard | |
|---|---|---|
| Sales by region & product | → | Charts in a window |
| Click a bar | → | Every visual filters (cross-filter) |
Why slicers aren't enough
To fake this in Excel you build several PivotCharts, add Slicers, and connect each slicer to each pivot through Report Connections. It's slow to assemble and slow to click through, and a slicer only filters from itself — it can't turn every chart into a filter you click. Genuine cross-filtering, where a click on any visual drives all the others, really only lives in Power BI.
The 1-click way — Tellsheet's Interactive Report
Select your table and run Interactive Report. Tellsheet opens a live dashboard in its own window where clicking any chart cross-filters every visual at once, Power BI-style — no slicers, no PivotCharts to wire up. It's built entirely from your selection and nothing leaves your PC. Pairs with Instant Dashboard and PivotTable Alternative.
Frequently asked questions
Does it cross-filter like Power BI?
Yes — click any chart and every other visual filters to match, without a single slicer to set up.
Do I need PivotCharts or slicers?
No — the dashboard is built straight from your selected table, so there's nothing to wire together.
Where does it open?
In its own window over Excel, so you can explore freely without changing your sheet.
Does my data get uploaded?
No — it's built and rendered on your PC; nothing is sent anywhere.
Related Excel guides
Cross-filter your data in one click
Interactive Report opens a live, click-to-filter dashboard from your table — Power BI-style, and it stays on your PC.
Get Tellsheet free See pricing