I have a chart legend with the series name Avg Rec'd # of Samples per Submittal. I want to add the formula ='2015'!$D$2 in front of the current series name. I tried the ampersand symbol after the formula i.e. ='2015'!$D$2&"Avg Rec'd # of Samples per Submittal", but it does not work. It doesn't seem to be a function of the sheet '2015'! being called out, as I tried it on a cell that was in the same sheet as the chart. Any suggestions?