View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
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