Sep 06

Excel Axis Labels from Two Columns

Say you have two columns of data, like the day of the week and the date, that you’d like to concatenate together as the X-axis labels on a chart. You could make a new column with a formula that concatenates them together and use that column for the X-axis, but I recently discovered, completely by accident, that Excel will do it for you! Simply set the Horizontal Axis Labels in your chart’s Select Data pane to a range from the top left cell to the bottom right cell of the columns you want to concatenate:

=Sheet1!$A$2:$B$20