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

Leave a Reply

Your email address will not be published. Required fields are marked *


*