Use VLOOKUP function to create dynamic charts – Excel Tips and Tricks
https://youtube.com/watch?v=RZH0zORV9doUse VLOOKUP function to create dynamic charts. Here are the steps featured in my video. Dynamic Chart Using VLOOKUP 1) Highlight the row like this 2) =VLOOKUP($B$5,$B$18:$F$33,COLUMN(B17),0) 3) Ctrl +…
