I've also been acknowledged being an Excel MVP by Microsoft for my passion to find out and educate persons on making use of Excel the ideal way. Dynamic charts allow you to change the chart based upon person selection. https://allytech.co.in/Advanced-Excel-&-Macros-VBA-training-btm.html