Excel Vertical text is an easy way to label groups of rows and make your charts more readable. This only takes a couple of clicks with Excel.

Excel Merge and Center

Start by adding a column to the left of your chart. Then select all of the cells in that column that are to the left of a group of rows. In this example, I selected the cells to the left of the mammals. Choose Merge and Center under the Alignment group under the Home tab.

Next, type into the newly merged cell your data label. Click on the Text Orientation button in the Alignment group and choose Vertical. You may also want to choose Wrap Text and the Center Alignment options.

Excel Vertical Alignment

Adjust the width of the column and add Cell styles as needed to decorate your Excel vertical text.

Excel Vertical Text labeling groups of rows



Excel Formatting is covered in these Excel classes:

See our other Excel topics.