Truncated y axis work-around - adding symbols

[Scott]

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.

[Jon Peltier]

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.

[Dylan Moran]

Hi Scott,

As Jon suggests, the workaround you can use is a pain. Unfortunately, but
put in three spaces and a full stop. Select the full stop and then colour the
same colour as your background (usually white) using the "Font Colour" (that
is the "A") on your formatting toolbar. You can colour individual elements of
text this way.

Alternatively, if you
1. Select you chart
2. Hold down Shift
3. Edit > Copy Picture
4. Choose the options Appearance : As shown when printed, and Size, As
shown on screen (or when printed).

Then click OK and then paste into where required this seems to work at times
as well.

Good luck.

If only it didn't trim the spaces at the end we would all be happy. Such a
simple solution. Maybe MS staff don't use MS Excel

--
I may not know VBA inside out, but from the outside I am looking in.
Dylan Moran - Melbourne Australia


"Jon Peltier" wrote:

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

[Scott]

Thanks for all the suggestions. I can't believe that more people don't find
this extremely annoying and MS doesn't fix it! When I double click on it, it
turns horizontal for editing as you suggest, but the font is all distorted,
ie missing the last part that was missing originally. The "save as picture"
seems to work ok, and just insert it in a word or power point document for
presentations.

"Dylan Moran" wrote:

> Hi Scott,
>
> As Jon suggests, the workaround you can use is a pain. Unfortunately, but
> put in three spaces and a full stop. Select the full stop and then colour the
> same colour as your background (usually white) using the "Font Colour" (that
> is the "A") on your formatting toolbar. You can colour individual elements of
> text this way.
>
> Alternatively, if you
> 1. Select you chart
> 2. Hold down Shift
> 3. Edit > Copy Picture
> 4. Choose the options Appearance : As shown when printed, and Size, As
> shown on screen (or when printed).
>
> Then click OK and then paste into where required this seems to work at times
> as well.
>
> Good luck.
>
> If only it didn't trim the spaces at the end we would all be happy. Such a
> simple solution. Maybe MS staff don't use MS Excel
>
> --
> I may not know VBA inside out, but from the outside I am looking in.
> Dylan Moran - Melbourne Australia
>
>
> "Jon Peltier" wrote:
>
> > 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.
> >
> >

[whistles28]

I have an LG LW65 notebook (widescreen - 1280x800, ATI X700) with the truncated Y axis label problem.
I managed to find a temporary fixing procedure that works for an entire Excel session:

1. close excel
2. change screen resolution to a 4:3 aspect ratio (800x600 or 1024x768)
3. open excel (now the y axis label should display correctly)
4. change screen resolution back to the original value (default)

You shouldn't have any problem while on that excel session. If you close excel, the problem seems to return when you reopen it. You'll have to repeat the procedure.
It's not perfect, but it worked for me.

Good luck!
Francisco