Justifying 2-line category names in bar charts
 

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.

Justifying 2-line category names in bar charts
 

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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Justifying 2-line category names in bar charts
 

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

"Andy Pope" wrote:

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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info