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
Please attach example file. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the document.
I created a new workbook and the problem was not there. The original workbook is a few years old. It appears that the legend was not resizing properly when new items like trend and mean lines were added when the formula cell was used. If plain text in a cell was used, the legend showed. I misattributed it to the formula. I create hundreds of graphs and normally when adding data ranges or trend / mean lines the legend grows to accommodate.