View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do I right justify the text labels in a chart?

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!