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