alignment of axis values

**bagullo** · 11-29-2009, 11:05 PM

hello there,

I have some bar charts where the axis values are rather long, extending 2 and even 3 lines

excel centers them by default, and any system I can think of to align them to the right does not seem work

any secret weapon out there to solve that?

thnks in advance

**teylyn** · 11-29-2009, 11:10 PM

Excel is quite unwieldy when it comes to formatting axis labels. It's a much lamented shortfall and not a lot you can do, save hiding the axis labels altogether and replacing them with text boxes. Of course, that's not dynamic, but for some cosmetic one-offs may be a viable approach.

Sorry not to be more helpful

**bagullo** · 11-29-2009, 11:44 PM

thnks again for the reassurance that I'm doing things in the best (and reasonable) way

regards

**Andy Pope** · 11-30-2009, 05:17 AM

Here is some code that will save you some time.
http://www.andypope.info/vba/Axislabel_textboxes.htm

**fharnyte** · 11-30-2009, 11:19 AM

I have tried this earlier. I have used Rotate text down and enlarged the chart size to fix it temporarily. It will display the axis values to multiple lines perhaps we have to compromise with chart size.