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!

  • I know that this is not an answer to what you are asking, however would typing 2015 Test Results, then formatting "Test Results" to use the same font color as the background, the in cell L11 work? – Clif May 11 '15 at 16:54

I assume you are trying to enter this formula in the actual Series Name dialog box for the chart. This does not work. Excel expects to see a reference to a single cell or range of cells and not a normal formula.

The normal way to handle this is to set the formula for the 'Series Name' in a cell, and then set the Series Name equal to this single cell.

Formula in C2

=E2&" Test Results"

Chart and data series ranges showing that the Series Name is equal to a single cell C2.

chart with ranges

  • Thank you very much. That is a very neat trick and I definitly didn't think of that. I did what you described and it worked beautifully! – M S May 11 '15 at 20:31

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.