<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><table border="1" cellspacing="0" cellpadding="8">
        <tr>
          <th>Bug ID</th>
          <td><a class="bz_bug_link 
          bz_status_UNCONFIRMED "
   title="UNCONFIRMED - Chart Legend does not display concatenated data"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=116732">116732</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Chart Legend does not display concatenated data
          </td>
        </tr>

        <tr>
          <th>Product</th>
          <td>LibreOffice
          </td>
        </tr>

        <tr>
          <th>Version</th>
          <td>6.0.2.1 release
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>x86-64 (AMD64)
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>All
          </td>
        </tr>

        <tr>
          <th>Status</th>
          <td>UNCONFIRMED
          </td>
        </tr>

        <tr>
          <th>Severity</th>
          <td>normal
          </td>
        </tr>

        <tr>
          <th>Priority</th>
          <td>medium
          </td>
        </tr>

        <tr>
          <th>Component</th>
          <td>Chart
          </td>
        </tr>

        <tr>
          <th>Assignee</th>
          <td>libreoffice-bugs@lists.freedesktop.org
          </td>
        </tr>

        <tr>
          <th>Reporter</th>
          <td>ieales@ielogical.com
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Description:
Using 
=CONCATENATE( INDEX(MonNames,1,D3), " to ", INDEX(MonNames,1,D4) )

 or

=INDEX(MonNames,1,D3) & " to " & INDEX(MonNames,1,D4) )

in a cell and referencing that cell for a [scatter] plot results in a blank
legend


Steps to Reproduce:
1. create formula to build concatenated text
2. reference above cell for legend text
3. legend shows as expected in Chart Edit Data Ranges dialog, but is blank on
chart

Actual Results:  
Blank legend on chart

Expected Results:
Legend displays cell text


Reproducible: Always


User Profile Reset: No



Additional Info:
version is what I'm using, may have always been...

Version: 6.0.2.1 (x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: en-US (en_US); Calc: group

problem exist on other machines, so did not reset user profile. I have a fair
bit of customization and don't want to lose it all.

OpenGL test site blocked by windows


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 Edge/16.16299</pre>
        </div>
      </p>


      <hr>
      <span>You are receiving this mail because:</span>

      <ul>
          <li>You are the assignee for the bug.</li>
      </ul>
    </body>
</html>