Justifying 2-line category names in bar charts

[Camille]

When a category name wraps on to 2 lines, Excel centers the second line under
the first. I'd like to figure out a way to right justify the second line.
I'd also like to figure out a way to set that as a default.

 

[Andy Pope]

Hi,

You do not have much control over the axis labels and their appearance.
If you want full control you will need to use textboxes.
This page has code to help with construction and alignment.

http://www.andypope.info/vba/Axislabel_textboxes.htm

Cheers
Andy

 

[Camille]

Thanks Andy. I'll try this out when I get to the office on Monday.
Camille