Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
maggie
 
Posts: n/a
Default In Excel the Y axis title box cuts off the last letter.

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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default In Excel the Y axis title box cuts off the last letter.

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

"maggie" wrote in message
...
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.



  #3   Report Post  
Posted to microsoft.public.excel.charting
maggie
 
Posts: n/a
Default In Excel the Y axis title box cuts off the last letter.

Many thanks, Bernard. Your're a star.

"Bernard Liengme" wrote:

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

"maggie" wrote in message
...
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.




  #4   Report Post  
Posted to microsoft.public.excel.charting
David
 
Posts: n/a
Default In Excel the Y axis title box cuts off the last letter.


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.


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?
  #5   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default In Excel the Y axis title box cuts off the last letter.

Hi,

Here is an MSKB article on the subject.
http://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:
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.



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?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


  #6   Report Post  
Posted to microsoft.public.excel.charting
David
 
Posts: n/a
Default In Excel the Y axis title box cuts off the last letter.



"Andy Pope" wrote:

Hi,

Here is an MSKB article on the subject.
http://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:
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.



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?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info



Andy,

Many thanks for your speedy response and the handy URL.

You have brought much clarity to the issue.

Cheers mate
  #7   Report Post  
Posted to microsoft.public.excel.charting
David
 
Posts: n/a
Default In Excel the Y axis title box cuts off the last letter.

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.


"Andy Pope" wrote:

Hi,

Here is an MSKB article on the subject.
http://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:
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.



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?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW TO CREATE A LETTER TEMPLATE IN EXCEL? Ravindra.C Excel Discussion (Misc queries) 1 January 30th 06 04:25 PM
Chaning X axis scale in Excel 2003 wendythelwell Charts and Charting in Excel 2 August 9th 05 02:35 PM
how do i make the excel chart axis title boxes bigger? Patrick98001 New Users to Excel 1 August 5th 05 09:13 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
The x-axis title is truncated in EXCEL charts 2003. Bernard Liengme Charts and Charting in Excel 0 November 26th 04 05:25 PM


All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"