peltiertech.com
Assign Chart Series Names or Categories with VBA - Peltier Tech Blog
This tutorial shows VBA code to find ranges or allow a user to select ranges that have series names or category labels and apply them to the active chart.