Hi
Does anyone know of a way to use a formula, such as =concatenate, to concatenate two cells together in a chart Series Name (Select Data -> Series Name)? It doesn't appear you can use formulas in Series Names.

Also, I do not want to put the two target cells together and refer to that cell. This will not work in the way I want to use this spreadsheet.


Paul