If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
In Excel the Y axis title box cuts off the last letter.
David,
I recently had the same problem with characters missing on the y-axis. One workaround that is easy as thus far has worked is to add several spaces at the end of the axis label then any character. The useless character is the one that is now missing and your intended label is intact. hope this helps, Diane "David" wrote: 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 "Andy Pope" wrote: 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: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#12
|
|||
|
|||
In Excel the Y axis title box cuts off the last letter.
I recently changed printers and came across this problem with both my chart
title and my y axis title, that I didn't have with my original printer. I don't know what this alt + 0160 means, but by adding three spaces at the end of the title and then the alt+0160 I got what I wanted. Thank you for making this an easy fix. "Diane" wrote: David, I recently had the same problem with characters missing on the y-axis. One workaround that is easy as thus far has worked is to add several spaces at the end of the axis label then any character. The useless character is the one that is now missing and your intended label is intact. hope this helps, Diane "David" wrote: 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 "Andy Pope" wrote: 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: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I could NOT resize the axis title but excel allows me to resize gr | Iwan Setiyono Ko | Charts and Charting | 0 | March 15th, 2006 10:34 AM |
axis title text box is wrong size in chart for excel 2003 | hey_scott | Charts and Charting | 3 | February 16th, 2006 12:25 AM |
Why do I not see the whole axis title in Excel? | Jennybr | Charts and Charting | 1 | November 22nd, 2005 01:09 PM |
Convert to Symbols | Omar Menjivar | General Discussion | 7 | June 27th, 2005 07:32 PM |
missing three letters of y axis title of chart in excel | Julie | Charts and Charting | 1 | May 13th, 2005 11:27 PM |