Excel Chart Revolution: One Formula, Zero Macros - Effortless Dropdown Switching!

[@mahrezchabane6895]

You're the best

[@Up4Excel]

I'm sure I'm not but I'll take the compliment anyway 😉 Thanks for watching and commenting 👍 John

[@johnborg5419]

Thanks John

[@Up4Excel]

Cheers John 👍

[@kimyenchu]

Does the region auto update if you add a new region to the table?

[@Up4Excel]

If you make the list of regions an Excel Table (Hit CTRL+T when on the list) then link the drop down to that range it will expand when the table size changes. I didn't do that on this video to keep the focus but I show exactly how to do it in this video: th-cam.com/video/QgL0BJq3SQk/w-d-xo.html

[@LadyOkere]

Thank you

[@Up4Excel]

You're welcome 👍John

[@amolgaikwad6977]

Amazing

[@Up4Excel]

Glad you think so, you'll be amazing now if you weren't already 👍John