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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Monica VH - 23 May 2008 21:52 GMT

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!

Reply to this Message

Jon Peltier - 24 May 2008 01:21 GMT

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
_______

> I've created a series of horizontal bar charts and all the text labels to
> the
[quoted text clipped - 4 lines]
> do
> this? Thanks!

Reply to this Message

Andy Pope - 24 May 2008 11:37 GMT

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

> 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!

Signature

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

Reply to this Message