Search code examples
excelchartsexcel-formulaworksheet-function

Concatenating Text in a Chart Series Name Box

I am trying to alter a chart legend / series name to concatenate some additional text to the series label from the original data set. Following the instructions found here, I get to the Select Data Source dialog, where I select the legend entry I want to change from the Legend Entries (Series) box, and then click Edit. That brings up this dialog:

Edit Series Dialog 1

What I want to do is concatenate some words to the original series label coming from that DATA!$C$3 field, like so:

enter image description here

However, when I do that, I get the familiar "The formula you typed contains an error" dialog. This to me is strange, because what I have there is a legal formula. It's almost as if only a subset of the formula syntax is supported in this dialog.

Is there a correct syntax or workaround for accomplishing this?

Solution

  • Although Jon Peltier credits "The series formula is an Excel formula like any other." it does seem a little quirky to me. He also mentions:

    The Series Name can be blank, a text string in double quotation marks, a reference to a worksheet range (one or more cells), or a reference to a named range (named formula).

    For simplicity, if viable you might consider going to Data!C3 and changing whatever is there (eg x) to: 

    ="x"&"(Rt. Axis)"