I have a workbook that contains numerous charts. I am updating the chart
trends by manually editing the formula that define the trend data.

I would like to create defined names, and through VBA, update the definition
for the ranges.

HOW do I incorporate a defined name into the formula for the trend?