Spaces in y-axis title

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble getting some y-axis titles to display correctly. If I
have either a Greek letter (symbol font) or a superscript number as part of
the axis title, an unwanted space appears immediately before this character.
This is not an actual space character like that created with the space bar,
because when I click on the axis title to edit it (so that it temporarily
appears horizontally), the space disappears so that I can't delete it. The
unwanted space comes back as soon as the axis title goes back to its normal
rotated position when I finish editing it.

The axis title looks the same both on the screen and when printed, so I
doubt it is due to screen resolution settings mentioned in some posts
referring to other axis title problems.

I'm using Excel 2003.

Thanks for any suggestions.
 
My usual substitute for chart-based text-type boxes (such as chart title,
axis title, etc.) is to simply add a textbox of my own. Select the chart
then from the Drawing toolbar select and add a textbox. Better formatting
and position control.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thanks Tushar - I actually tried this and still got the same problem. After
doing some more playing around it seems that the problem is worse if the axis
title is fairly long - the unwanted space isn't noticeable if the axis title
is only a few characters long (this applies to both a y-axis title and a text
box with the text rotated - but doesn't happen with horizontal text in a text
box). However, if I break my axis title over two lines, the problem doesn't
seem to happen - so I guess that's what I'll have to do unless anyone has any
other suggestions.

Maybe this is a bug? Has anyone else experienced this?
 
Back
Top