issues with justification of bar descriptiors

[Em]

Hi there,

I'm having a very specific problem with excel that I've tried to solve but
can't - hoping for some help!

I have a number of graphs that are turned on their side - that being that
the bars are running horizontally from left to right rather than vertically.

In the y-axis is the text describing what the various bars are - it is also
running horizontally. If the text is too long, some of the text gets bumped
to a second line.

Now here's the problem.... I can justify the first line of text but I seem
to have no control over the second line of text, it's always centered in the
axis which looks pretty sloppy. I'd like to right justify it.

Yikes! Any ideas???

With thanks,
Em