Horizontal axis labels in Bar Charts

**jeskit** · 08-15-2011, 03:36 AM

Hi

I created a bar chart in Excel 2010 and for some reason the horizontal axis labels have gone diagonal instead of straight down. I have attached a image of the to give an example.

I tried setting the axis type to Text which normally works but it has not worked this time. Does anyone know how to make the text go straight down on this bar chart?

Thanks

Jeskit

**ianh** · 08-15-2011, 04:26 AM

Double click on the axis. In the format axis box that opens up goto the "alignment" tab and change the text direction option to "rotated" or "vertical" depending on the style you need.