View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Scott -

This axis title truncation can be a royal pain. The best you can do is use a lame
workaround such as you describe.

You can click once to select the Y axis title, then again to enable editing: the
text turns horizontal temporarily, and the flashing cursor appears. Select one or
more characters, and format them using the normal text formatting tools.

To get the micro sign, the Greek letter mu, hold down the Alt key while pressing
0181 on the number keypad: ยต. I have a little utility that shows all of these
Alt+XXXX keystrokes, and allows you to see the characters in several selected fonts:

http://peltiertech.com/Excel/Zips/ascii.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Scott wrote:

I have the very frustrating abve problem on my lap top. It displays OK on my
desktop. I can't fix it by changing my screen resolution as microsoft
suggest, however, fortunately, it prints OK. I work around this my adding a
bunch of spaces at the end and then a "." I have heard that you can hide the
"." by coloring it the same as the background. How do you format the text in
this box individually, ie I can change the font and color for the whole line,
but not one letter. I would also like to add a symbol ie ug/ml with the
microgram symbol. How can I add this? I tried a text box, but even that
appears truncated when I rotate text on my laptop.