Simple IF Function, Data Validation, Conditional Formatting to get a Quick Dynamic Report (Chart)
Some times, you can use simple basics of Excel to show best results and within no time.
In this video I have explained how to use Conditional formatting, IF Function and Data validation (List) to create a Dynamic Chart within 10 minutes.