Apparently the charting wizard doesn't allow concatenations, if you tr
that formula in a worksheet it works correctly, but not when giving
name to a data source in the chart or title

Until Excel-Forum fixes its threading, you'll need to include some part
of the reply so that someone (not on Excel-Forum, i.e., the vast
majority of readers) can tell what you mean by "that"...