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!

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Monica VH" <Monica wrote in message
...
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!

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

Monica VH wrote:
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!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info