How to make a dynamic chart using data validation

In this video I show you how to make a dynamic chart in excel using data validation to create a dropdown list. In this example I create a chart where the x axis and y axis are compound concentrations from air samples and the compounds on both axis can be changed to look at the correlations between different compounds.
---------------------------------------------------------------------------------
#exceltutorials #exceltipsandtricks #excelcharts

VIDEO INFO: These data are related to my PhD research.
---------------------------------------------------------------------------------
IF YOU LIKE THIS VIDEO YOU MAY ALSO LIKE:

[irohalabdellah]

continue, the world need your service

[vasanthavasu]

for that C2F6 and C3F8 ....etc columns you kept validations for that...and that's fine, , , if I want to keep validation for dates also in your data at a time need to change both validates and need to change accordingly what we have to do?