Slicer to control multiple Data Tables (NOT Pivot Tables) - Excel 2016

[jacksugrue]

I am running Excel 2016 and have multiple tables (NOT Pivot Tables) in my spreadsheet that all have a Date column and charts built off of the various tables.

I have created a slicer for one of the tables and it controls both the data table and the charts built off of that table.

Is there any way to apply that same slicer to the other tables (and therefore, the charts build off of those tables).

I am NOT talking about Pivot Tables - there are lots of examples out there on how to use a single slicer on multiple Pivot Tables. I cannot find anything on using 1 slicer for multiple NON-Pivot Tables.

Any help would be appreciated.

 

[FEED_ME_STATS]

I am running Excel 2016 and have multiple tables (NOT Pivot Tables) in my spreadsheet that all have a Date column and charts built off of the various tables.

I have created a slicer for one of the tables and it controls both the data table and the charts built off of that table.

Is there any way to apply that same slicer to the other tables (and therefore, the charts build off of those tables).

I am NOT talking about Pivot Tables - there are lots of examples out there on how to use a single slicer on multiple Pivot Tables. I cannot find anything on using 1 slicer for multiple NON-Pivot Tables.

Any help would be appreciated.

I don't think it is possible, but I use a work around because I can't stand the limitations that come with a pivot chart as apposed to using a regular chart. I use a work around to do it. Make a pivot table from the regular table with all the lookup information needed . Install a new regular table next to the pivot table and pull the data over by simple making it = the cells from pivot on the new table. Add an if function with a NA function for cells with no data to force an error so the empty cells don't show on the chart. Build this for all your tables and hook up the slicers to the pivots