Excel Impressive Trick - Scrolling Dynamic Charts

Creating dynamic changeable charts and graphs in Excel is much easier than believed. Using HLOOKUP | VLOOKUP | XLOOKUP, an activeX control (or a forms control), and some simple index numbers we can easily create a dynamic chart that will allow us to quickly change the timeline of any chart and dynamically sift through a data set without having to view it all at the same time. This is a cool little trick that most people won't know about and allows you to show off a little in Excel without having to do a ton of extra work.