Updating Trendline Labels

[byeonyj]

Hello,

I have a question that is moderately easy to grasp.

I have an chart output in Worksheet 2, with some data in Worksheet 1.
I know how to connect the data sets, so that when I add new data, the chart automatically reflects the changes.

HOWEVER, I am not able to Auto-Update the legend/name/title of the individual lines in the chart.
For example, I want to put "Jul-31 Secondary", with the updates made as the date goes on.

I was able to get it as close as "Power (Jul-31 Secondary)", as I went into Select Data to:
1. have two individual cells be the title of the Data Set, for which the first one is linked to a cell with dates (Jul-31), second including the word ("Secondary")
2. use the "Automatic" naming function

But the problem is the "POWER" infront of the text, as I just want the "date+Secondary"
I have done this through the Custom labeling function, but would either like (a) a Macro, or (b) a way to omit the word "Power" when using automatic labeling (although it needs to be a Power line)


Trivial matter, but not so unimportant in a corporate deliverable.


Thanks in advance!