Certainly. And might not even need VBA. Review this tutorial https://www.automateexcel.com/charts...ctive-dynamic/