software

The Y axis title box always cuts off the last letter no matter what type or
size of font. It doesn't matter how many letters either 5 or 15, the last one
is aways missing.

A known bug (only some users experience it).
Workaround: add some dots (.....) to end of the title and format them with
font of the same colour as the title background.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;maggiequot; gt; wrote in message
...
gt; The Y axis title box always cuts off the last letter no matter what type
gt; or
gt; size of font. It doesn't matter how many letters either 5 or 15, the last
gt; one
gt; is aways missing.
Many thanks, Bernard. Your're a star.

quot;Bernard Liengmequot; wrote:

gt; A known bug (only some users experience it).
gt; Workaround: add some dots (.....) to end of the title and format them with
gt; font of the same colour as the title background.
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;maggiequot; gt; wrote in message
gt; ...
gt; gt; The Y axis title box always cuts off the last letter no matter what type
gt; gt; or
gt; gt; size of font. It doesn't matter how many letters either 5 or 15, the last
gt; gt; one
gt; gt; is aways missing.
gt;
gt;
gt;


gt; gt; A known bug (only some users experience it).
gt; gt; Workaround: add some dots (.....) to end of the title and format them with
gt; gt; font of the same colour as the title background.

Bernard, if it is a 'known' bug, why isn't there a better way to fix it?

I have tried the technique you passed onto Maggie, however I use excel quite
a bit (this forum is the only place I have found any information regarding my
troubles with the y axis labels) and it is so time consuming screwing around
with the fonts.

How else can this be fixed? Will a re-install help?

Hi,

Here is an MSKB article on the subject.
support.microsoft.com/default...b;en-us;870698

You could try adding a non breaking space to the end of the text. Use
ALT 0160 (from the numeric key pad).

Cheers
Andy

David wrote:
gt;gt;gt;A known bug (only some users experience it).
gt;gt;gt;Workaround: add some dots (.....) to end of the title and format them with
gt;gt;gt;font of the same colour as the title background.
gt;
gt;
gt; Bernard, if it is a 'known' bug, why isn't there a better way to fix it?
gt;
gt; I have tried the technique you passed onto Maggie, however I use excel quite
gt; a bit (this forum is the only place I have found any information regarding my
gt; troubles with the y axis labels) and it is so time consuming screwing around
gt; with the fonts.
gt;
gt; How else can this be fixed? Will a re-install help?

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info



quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; Here is an MSKB article on the subject.
gt; support.microsoft.com/default...b;en-us;870698
gt;
gt; You could try adding a non breaking space to the end of the text. Use
gt; ALT 0160 (from the numeric key pad).
gt;
gt; Cheers
gt; Andy
gt;
gt; David wrote:
gt; gt;gt;gt;A known bug (only some users experience it).
gt; gt;gt;gt;Workaround: add some dots (.....) to end of the title and format them with
gt; gt;gt;gt;font of the same colour as the title background.
gt; gt;
gt; gt;
gt; gt; Bernard, if it is a 'known' bug, why isn't there a better way to fix it?
gt; gt;
gt; gt; I have tried the technique you passed onto Maggie, however I use excel quite
gt; gt; a bit (this forum is the only place I have found any information regarding my
gt; gt; troubles with the y axis labels) and it is so time consuming screwing around
gt; gt; with the fonts.
gt; gt;
gt; gt; How else can this be fixed? Will a re-install help?
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.infoAndy,

Many thanks for your speedy response and the handy URL.

You have brought much clarity to the issue.

Cheers mate

Although, just tried to change the screen ratios (as mentioned in the MSKB
article) and that didn't fix it.

How common is this problem and secondly, is there any chance of some sort of
patch/update will be made available by microsoft in order to rectify it?

The workaround method aforementioned by Bernard, whilst it works, is way too
time consuming.quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; Here is an MSKB article on the subject.
gt; support.microsoft.com/default...b;en-us;870698
gt;
gt; You could try adding a non breaking space to the end of the text. Use
gt; ALT 0160 (from the numeric key pad).
gt;
gt; Cheers
gt; Andy
gt;
gt; David wrote:
gt; gt;gt;gt;A known bug (only some users experience it).
gt; gt;gt;gt;Workaround: add some dots (.....) to end of the title and format them with
gt; gt;gt;gt;font of the same colour as the title background.
gt; gt;
gt; gt;
gt; gt; Bernard, if it is a 'known' bug, why isn't there a better way to fix it?
gt; gt;
gt; gt; I have tried the technique you passed onto Maggie, however I use excel quite
gt; gt; a bit (this forum is the only place I have found any information regarding my
gt; gt; troubles with the y axis labels) and it is so time consuming screwing around
gt; gt; with the fonts.
gt; gt;
gt; gt; How else can this be fixed? Will a re-install help?
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;

The question has been posted 3 times this week and I would say that's
normal.

As to MS fixing the problem, IMHO, not likely whilst their efforts are
directed towards Office 2007. As a patch to older xl version unlikely as
the problem is not always reproducible. I personally have not encounter
the truncating of chart titles on any of the hardware I use but I know
the problem exists.

Did the non breaking space solution not work for you?

Cheers
Andy

David wrote:
gt; Although, just tried to change the screen ratios (as mentioned in the MSKB
gt; article) and that didn't fix it.
gt;
gt; How common is this problem and secondly, is there any chance of some sort of
gt; patch/update will be made available by microsoft in order to rectify it?
gt;
gt; The workaround method aforementioned by Bernard, whilst it works, is way too
gt; time consuming.
gt;
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;
gt;gt;Hi,
gt;gt;
gt;gt;Here is an MSKB article on the subject.
gt;gt;support.microsoft.com/default...b;en-us;870698
gt;gt;
gt;gt;You could try adding a non breaking space to the end of the text. Use
gt;gt;ALT 0160 (from the numeric key pad).
gt;gt;
gt;gt;Cheers
gt;gt;Andy
gt;gt;
gt;gt;David wrote:
gt;gt;
gt;gt;gt;gt;gt;A known bug (only some users experience it).
gt;gt;gt;gt;gt;Workaround: add some dots (.....) to end of the title and format them with
gt;gt;gt;gt;gt;font of the same colour as the title background.
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;Bernard, if it is a 'known' bug, why isn't there a better way to fix it?
gt;gt;gt;
gt;gt;gt;I have tried the technique you passed onto Maggie, however I use excel quite
gt;gt;gt;a bit (this forum is the only place I have found any information regarding my
gt;gt;gt;troubles with the y axis labels) and it is so time consuming screwing around
gt;gt;gt;with the fonts.
gt;gt;gt;
gt;gt;gt;How else can this be fixed? Will a re-install help?
gt;gt;
gt;gt;--
gt;gt;
gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;www.andypope.info
gt;gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Can't really blame them for that I guess

I just tried you non-break solution, however am using a notebook w/o number
pad.

But I do have an fn key and a number pad on the keyboard when fn is pressed.

Will that work?

If so, I am typing (whilst holding fn): ALT then 0160. Also tried ALT then
then 0160 and both are not fixing the problem.

Looks like we all have to just put up or shut up

Thanks Andy

quot;Andy Popequot; wrote:

gt; The question has been posted 3 times this week and I would say that's
gt; normal.
gt;
gt; As to MS fixing the problem, IMHO, not likely whilst their efforts are
gt; directed towards Office 2007. As a patch to older xl version unlikely as
gt; the problem is not always reproducible. I personally have not encounter
gt; the truncating of chart titles on any of the hardware I use but I know
gt; the problem exists.
gt;
gt; Did the non breaking space solution not work for you?
gt;
gt; Cheers
gt; Andy
gt;
gt; David wrote:
gt; gt; Although, just tried to change the screen ratios (as mentioned in the MSKB
gt; gt; article) and that didn't fix it.
gt; gt;
gt; gt; How common is this problem and secondly, is there any chance of some sort of
gt; gt; patch/update will be made available by microsoft in order to rectify it?
gt; gt;
gt; gt; The workaround method aforementioned by Bernard, whilst it works, is way too
gt; gt; time consuming.
gt; gt;
gt; gt;
gt; gt; quot;Andy Popequot; wrote:
gt; gt;
gt; gt;
gt; gt;gt;Hi,
gt; gt;gt;
gt; gt;gt;Here is an MSKB article on the subject.
gt; gt;gt;support.microsoft.com/default...b;en-us;870698
gt; gt;gt;
gt; gt;gt;You could try adding a non breaking space to the end of the text. Use
gt; gt;gt;ALT 0160 (from the numeric key pad).
gt; gt;gt;
gt; gt;gt;Cheers
gt; gt;gt;Andy
gt; gt;gt;
gt; gt;gt;David wrote:
gt; gt;gt;
gt; gt;gt;gt;gt;gt;A known bug (only some users experience it).
gt; gt;gt;gt;gt;gt;Workaround: add some dots (.....) to end of the title and format them with
gt; gt;gt;gt;gt;gt;font of the same colour as the title background.
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;gt;Bernard, if it is a 'known' bug, why isn't there a better way to fix it?
gt; gt;gt;gt;
gt; gt;gt;gt;I have tried the technique you passed onto Maggie, however I use excel quite
gt; gt;gt;gt;a bit (this forum is the only place I have found any information regarding my
gt; gt;gt;gt;troubles with the y axis labels) and it is so time consuming screwing around
gt; gt;gt;gt;with the fonts.
gt; gt;gt;gt;
gt; gt;gt;gt;How else can this be fixed? Will a re-install help?
gt; gt;gt;
gt; gt;gt;--
gt; gt;gt;
gt; gt;gt;Andy Pope, Microsoft MVP - Excel
gt; gt;gt;www.andypope.info
gt; gt;gt;
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;

fn ALT_0160 works, adds a non breaking space, on my non numeric'd laptop.

You could try this in order to test for sure. In a cell enter the formula
=quot;My title textquot; amp; CHAR(160)

copy and paste special values into another cell. Now copy and paste the
text, which should include the non breaking space, into the title.

Cheers
Andy

David wrote:
gt; Can't really blame them for that I guess
gt;
gt; I just tried you non-break solution, however am using a notebook w/o number
gt; pad.
gt;
gt; But I do have an fn key and a number pad on the keyboard when fn is pressed.
gt;
gt; Will that work?
gt;
gt; If so, I am typing (whilst holding fn): ALT then 0160. Also tried ALT then
gt; then 0160 and both are not fixing the problem.
gt;
gt; Looks like we all have to just put up or shut up
gt;
gt; Thanks Andy
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;
gt;gt;The question has been posted 3 times this week and I would say that's
gt;gt;normal.
gt;gt;
gt;gt;As to MS fixing the problem, IMHO, not likely whilst their efforts are
gt;gt;directed towards Office 2007. As a patch to older xl version unlikely as
gt;gt;the problem is not always reproducible. I personally have not encounter
gt;gt;the truncating of chart titles on any of the hardware I use but I know
gt;gt;the problem exists.
gt;gt;
gt;gt;Did the non breaking space solution not work for you?
gt;gt;
gt;gt;Cheers
gt;gt;Andy
gt;gt;
gt;gt;David wrote:
gt;gt;
gt;gt;gt;Although, just tried to change the screen ratios (as mentioned in the MSKB
gt;gt;gt;article) and that didn't fix it.
gt;gt;gt;
gt;gt;gt;How common is this problem and secondly, is there any chance of some sort of
gt;gt;gt;patch/update will be made available by microsoft in order to rectify it?
gt;gt;gt;
gt;gt;gt;The workaround method aforementioned by Bernard, whilst it works, is way too
gt;gt;gt;time consuming.
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;quot;Andy Popequot; wrote:
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;gt;Hi,
gt;gt;gt;gt;
gt;gt;gt;gt;Here is an MSKB article on the subject.
gt;gt;gt;gt;support.microsoft.com/default...b;en-us;870698
gt;gt;gt;gt;
gt;gt;gt;gt;You could try adding a non breaking space to the end of the text. Use
gt;gt;gt;gt;ALT 0160 (from the numeric key pad).
gt;gt;gt;gt;
gt;gt;gt;gt;Cheers
gt;gt;gt;gt;Andy
gt;gt;gt;gt;
gt;gt;gt;gt;David wrote:
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;A known bug (only some users experience it).
gt;gt;gt;gt;gt;gt;gt;Workaround: add some dots (.....) to end of the title and format them with
gt;gt;gt;gt;gt;gt;gt;font of the same colour as the title background.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;Bernard, if it is a 'known' bug, why isn't there a better way to fix it?
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;I have tried the technique you passed onto Maggie, however I use excel quite
gt;gt;gt;gt;gt;a bit (this forum is the only place I have found any information regarding my
gt;gt;gt;gt;gt;troubles with the y axis labels) and it is so time consuming screwing around
gt;gt;gt;gt;gt;with the fonts.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;How else can this be fixed? Will a re-install help?
gt;gt;gt;gt;
gt;gt;gt;gt;--
gt;gt;gt;gt;
gt;gt;gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;gt;gt;www.andypope.info
gt;gt;gt;gt;
gt;gt;
gt;gt;--
gt;gt;
gt;gt;Andy Pope, Microsoft MVP - Excel
gt;gt;www.andypope.info
gt;gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info