Connect a slicer to a chart in Google Sheets
The line chart already uses this table. Select A1:D6 and add a slicer for Region so the slicer and chart use the same source data. Leave all values visible and do not change any cells or the chart.
Verified by PhilisAbout 60 secondsThe line chart already uses this table. Select A1:D6 and add a slicer for Region so the slicer and chart use the same source data. Leave all values visible and do not change any cells or the chart.
Step-by-step
Select the targetThe line chart already uses this table.
Complete the next actionSelect A1:D6 and add a slicer for Region so the slicer and chart use the same source data.
Apply the changeLeave all values visible and.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
A Region slicer and the line chart both use A1:D6.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Re-select A1:D6 and repeat the final action. A Region slicer and the line chart both use A1:D6.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Region | Owner | Status | Revenue |
| West | Anna | Open | 1200 |
| East | Ben | Closed | 900 |
| West | Cara | Open | 1500 |
| North | Dev | Closed | 1100 |
| East | Eva | Open | 1300 |
Video transcript
- Open the prepared Regional revenue spreadsheet.
- Select the target. The line chart already uses this table.
- Complete the next action. Select A1:D6 and add a slicer for Region so the slicer and chart use the same source data.
- Apply the change. Leave all values visible and.
- A Region slicer and the line chart both use A1:D6.