I'm having an issue trying to figure out how to create a 'Series Name' for a line chart in Excel to a TEXT + CELL value.
For example, I have two cells labeled 2015 and 2005 in Excel. In my chart, I want the 'Series Name' to be:
2015 + " Test Results"
2005 + " Test Results" Where 2015 and 2005 are cells L11 and L12 in my sheet.
I have tried the following:
=Sheet2!$L$11&" Test Results" =Sheet2!$L$11" Test Results"
I get the error "The formula you typed contains an error."
Not sure what else to try. Any help would be greatly appreciated!