How do I right justify the text labels in a chart?

[Monica VH]

I've created a series of horizontal bar charts and all the text labels to the
left of the chart categories are centered. I want them to be right-justified
so that the labels adjoin the chart bars. The right justify button on the
tool bar can't be clicked. Does anyone have any suggestions on how I can do
this? Thanks!

 

[Jon Peltier]

Excel doesn't let you change that alignment, unfortunately. You could try
making the whole chart wider or choose shorter labels, so they don't have to
wrap onto two lines. Or you could try replacing the category labels with
text boxes, which give you more formatting flexibility, but they tend to
wander (or at least are hard to position).

- Jon

 

[Andy Pope]

Hi,

I have posted some vba code to help with the textbox approach Jon mentioned.
http://www.andypope.info/vba/Axislabel_textboxes.htm

Cheers
Andy