title: Concatenating Text in a Chart Series Name Box
body: <p>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 <a href="https://support.office.com/en-au/article/Modify-chart-legend-entries-d822dd57-af28-4c3e-93d1-d320e6239843" rel="nofollow noreferrer">here</a>, I get to the <strong>Select Data Source</strong> dialog, where I select the legend entry I want to change from the <strong>Legend Entries (Series)</strong> box, and then click <strong>Edit</strong>.  That brings up this dialog:</p>
  
  <p><img src="https://i.stack.imgur.com/VRM0X.jpg" alt="Edit Series Dialog 1"></p>
  
  <p>What I want to do is concatenate some words to the original series label coming from that <code>DATA!$C$3</code> field, like so:</p>
  
  <p><img src="https://i.stack.imgur.com/TlBIl.jpg" alt="enter image description here"></p>
  
  <p>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.  </p>
  
  <p>Is there a correct syntax or workaround for accomplishing this?</p>