I want the x axis to be the concatination of columns A and B. Both are named ranges so I tried (under source data Category (x) axis labels):
=Worksheet!nameA & Worksheet!nameB
or
=TEXT(Worksheet!NameA & Worksheet!nameB)

Of course, neither worked. Is there a way to do this without concatinating in the data itself? Both cells are text values to begin with. Thanks in advance

Chemist B