Slicers work by default with Tables and Pivots.
Of course if the Tables are made as stated using CTRL+T and not just adding cell borders like in Word
For work I made dashboards with charts using a combination of Table and Pivot, but didn't make Pivot charts because I ran into some formatting problems - for some reason when working with Pivot charts and Slicers, the formatting of the chart wouldn't be kept between various Slicer option changes (see animated gifs below).
So I made my charts manually by adding series from ranges of data "behind" the Pivot tables.
1 - Pivot chart made from Pivot table - you can see that if you select 2 years it ruins the formatting, which remains ruined even after going back to one year selection (data range is PivotTable2)
Attachment 648488
2 - the chart is not Pivot chart but has the range "behind" the Pivot table as source - you can see that the formatting is kept even if selecting multiple years then going back to one (data range is $O$6:$Q$18, where PivotTable2 is)
Attachment 648487
So to finally answer your question it is possible by using both Tables and Pivot tables, but it prevents some problems if you make normal charts instead of Pivot charts, even from Pivot tables as chart sources.
Just my opinion, some people here might know a solution using the Pivot chart as well.
I had to make normal charts from Pivots because I could find no other way to keep my formatting.
Bookmarks