How to make a dynamic chart using slicers in excel

Convert the values into an excel table. Then on the 'Table Design' tab select 'Insert Slicer'. Make a chart for the whole of the table. Then you can use the slicer to filter the table and the chart.
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelcharts

SUBSCRIBE: https://goo.gl/c46YPs

Microsoft Office 365, 2016, Office Insider, Version 2001

These data are related to my PhD research
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
How to make dynamic charts in excel    • How to make dynamic charts in excel  
How to make a dynamic chart using data validation    • How to make a dynamic chart using dat...  
How to create a dropdown box in excel    • How to create a dropdown box in excel