A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Y-Axis Label



 
 
Thread Tools Display Modes
  #1  
Old November 22nd, 2005, 06:55 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Y-Axis Label


When I label the y-axis on a chart, the last couple of letters are cut
off and not displayed. If I print, the label prints fine (nothing
missing) but if I copy the graph and paste it into Word, the letters
are missing. This doesn't happen to the x-axis label. If I turn the
y-axis label around 90 degrees (so it isn't on it's side) it doesn't
happen either, but it looks silly with the text that way. This is
proving very frustrating!!

Does anyone know why, or how to fix this?

EDITED TO ADD: I'm using Excel 2003. And if I send the workbook to
someone else (who is also using 2003) they don't have the same problem
(come to think of it, neither did I until about a week ago).


--
LittleEm
------------------------------------------------------------------------
LittleEm's Profile: http://www.excelforum.com/member.php...o&userid=13250
View this thread: http://www.excelforum.com/showthread...hreadid=487114

  #2  
Old November 22nd, 2005, 02:03 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Y-Axis Label

What changed a week ago? New monitor? Install a new font? Buy a puppy?

This is an intermittent problem, and seems to depend on a combination of
screen resolution (wide aspect ratio monitors being more susceptible), zoom
factor, font and font size, and perhaps other undefinables. I've only had
the problem on my computer once, with a strangely formatted workbook from a
client. Some people get it frequently. It has occurred since at least Excel
5, but was relatively rare before the wide screens came out.

There seems to be no fix for the problem. A lame workaround is to type a
couple spaces at the end of the title followed by a period (the spaces alone
will not stretch the pseudo textbox). To hide the period from a user who is
not having this problem, select the last character of the title (the period)
and color the text to match the background.

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


"LittleEm" wrote in
message ...

When I label the y-axis on a chart, the last couple of letters are cut
off and not displayed. If I print, the label prints fine (nothing
missing) but if I copy the graph and paste it into Word, the letters
are missing. This doesn't happen to the x-axis label. If I turn the
y-axis label around 90 degrees (so it isn't on it's side) it doesn't
happen either, but it looks silly with the text that way. This is
proving very frustrating!!

Does anyone know why, or how to fix this?

EDITED TO ADD: I'm using Excel 2003. And if I send the workbook to
someone else (who is also using 2003) they don't have the same problem
(come to think of it, neither did I until about a week ago).


--
LittleEm
------------------------------------------------------------------------
LittleEm's Profile:
http://www.excelforum.com/member.php...o&userid=13250
View this thread: http://www.excelforum.com/showthread...hreadid=487114



  #3  
Old November 22nd, 2005, 02:17 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Y-Axis Label

Hi Jon,

I have not had this problem or been able to reproduce it but as a
thought. Rather than using spaces and a period to extend the title box
how about using non-breaking spaces (ALT+0160 from number pad). These do
seem to extend the title boxes.

Cheers
Andy

Jon Peltier wrote:
What changed a week ago? New monitor? Install a new font? Buy a puppy?

This is an intermittent problem, and seems to depend on a combination of
screen resolution (wide aspect ratio monitors being more susceptible), zoom
factor, font and font size, and perhaps other undefinables. I've only had
the problem on my computer once, with a strangely formatted workbook from a
client. Some people get it frequently. It has occurred since at least Excel
5, but was relatively rare before the wide screens came out.

There seems to be no fix for the problem. A lame workaround is to type a
couple spaces at the end of the title followed by a period (the spaces alone
will not stretch the pseudo textbox). To hide the period from a user who is
not having this problem, select the last character of the title (the period)
and color the text to match the background.

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


"LittleEm" wrote in
message ...

When I label the y-axis on a chart, the last couple of letters are cut
off and not displayed. If I print, the label prints fine (nothing
missing) but if I copy the graph and paste it into Word, the letters
are missing. This doesn't happen to the x-axis label. If I turn the
y-axis label around 90 degrees (so it isn't on it's side) it doesn't
happen either, but it looks silly with the text that way. This is
proving very frustrating!!

Does anyone know why, or how to fix this?

EDITED TO ADD: I'm using Excel 2003. And if I send the workbook to
someone else (who is also using 2003) they don't have the same problem
(come to think of it, neither did I until about a week ago).


--
LittleEm
------------------------------------------------------------------------
LittleEm's Profile:
http://www.excelforum.com/member.php...o&userid=13250
View this thread: http://www.excelforum.com/showthread...hreadid=487114





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #4  
Old November 23rd, 2005, 01:32 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Y-Axis Label

Andy -

That's a nice thought. I'll check it out, then amend my standard reply to
this question.

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

"Andy Pope" wrote in message
...
Hi Jon,

I have not had this problem or been able to reproduce it but as a thought.
Rather than using spaces and a period to extend the title box how about
using non-breaking spaces (ALT+0160 from number pad). These do seem to
extend the title boxes.

Cheers
Andy

Jon Peltier wrote:
What changed a week ago? New monitor? Install a new font? Buy a puppy?

This is an intermittent problem, and seems to depend on a combination of
screen resolution (wide aspect ratio monitors being more susceptible),
zoom factor, font and font size, and perhaps other undefinables. I've
only had the problem on my computer once, with a strangely formatted
workbook from a client. Some people get it frequently. It has occurred
since at least Excel 5, but was relatively rare before the wide screens
came out.

There seems to be no fix for the problem. A lame workaround is to type a
couple spaces at the end of the title followed by a period (the spaces
alone will not stretch the pseudo textbox). To hide the period from a
user who is not having this problem, select the last character of the
title (the period) and color the text to match the background.

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


"LittleEm" wrote
in message ...

When I label the y-axis on a chart, the last couple of letters are cut
off and not displayed. If I print, the label prints fine (nothing
missing) but if I copy the graph and paste it into Word, the letters
are missing. This doesn't happen to the x-axis label. If I turn the
y-axis label around 90 degrees (so it isn't on it's side) it doesn't
happen either, but it looks silly with the text that way. This is
proving very frustrating!!

Does anyone know why, or how to fix this?

EDITED TO ADD: I'm using Excel 2003. And if I send the workbook to
someone else (who is also using 2003) they don't have the same problem
(come to think of it, neither did I until about a week ago).


--
LittleEm
------------------------------------------------------------------------
LittleEm's Profile:
http://www.excelforum.com/member.php...o&userid=13250
View this thread:
http://www.excelforum.com/showthread...hreadid=487114





--

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



  #5  
Old November 24th, 2005, 12:30 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Y-Axis Label


Thanks for the replies.

Nothing has really changed - it's my work PC, I haven't changed
anything and if the administrators have they haven't told us about it.
I do have a widescreen monitor though (but have had it for several
months before this problem occurred).

I have been doing the spaces and full stop thing, but I have heaps of
charts that I use regularly and it's very time consuming!! By the
sounds of it though, there is no fix, so I'm hoping that one day it
will disappear as mysteriously as it arrived


--
LittleEm
------------------------------------------------------------------------
LittleEm's Profile: http://www.excelforum.com/member.php...o&userid=13250
View this thread: http://www.excelforum.com/showthread...hreadid=487114

  #6  
Old November 24th, 2005, 03:39 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Y-Axis Label


LittleEm Wrote:
When I label the y-axis on a chart, the last couple of letters are cut
off and not displayed. If I print, the label prints fine (nothing
missing) but if I copy the graph and paste it into Word, the letters
are missing. This doesn't happen to the x-axis label. If I turn the
y-axis label around 90 degrees (so it isn't on it's side) it doesn't
happen either, but it looks silly with the text that way. This is
proving very frustrating!!

Does anyone know why, or how to fix this?

EDITED TO ADD: I'm using Excel 2003. And if I send the workbook to
someone else (who is also using 2003) they don't have the same problem
(come to think of it, neither did I until about a week ago).



I have the same problem. Since the problem, I had to format pc and
again installed offfice 2003 etc. But nothing is changed. My laptop has
resolution of 1280*800 with ati mobility radeon 128mb.

If I write a long "Y" title in the graph, it doesnt compeletely appear
on the screen. Please a solution. I found on the net which is on the
http://support.microsoft.com/?kbid=8...tosh#appliesto link
adress. I tried the instructions in there but it doesnt change
anything. I set the resolution to 1024*768 but no useful.


--
niti
------------------------------------------------------------------------
niti's Profile: http://www.excelforum.com/member.php...o&userid=29068
View this thread: http://www.excelforum.com/showthread...hreadid=487114

  #7  
Old December 3rd, 2005, 04:50 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Y-Axis Label

The only cure I know of involves incense and the full moon, and maybe
chicken feathers.

- Jon

"LittleEm" wrote in
message ...

Thanks for the replies.

Nothing has really changed - it's my work PC, I haven't changed
anything and if the administrators have they haven't told us about it.
I do have a widescreen monitor though (but have had it for several
months before this problem occurred).

I have been doing the spaces and full stop thing, but I have heaps of
charts that I use regularly and it's very time consuming!! By the
sounds of it though, there is no fix, so I'm hoping that one day it
will disappear as mysteriously as it arrived


--
LittleEm
------------------------------------------------------------------------
LittleEm's Profile:
http://www.excelforum.com/member.php...o&userid=13250
View this thread: http://www.excelforum.com/showthread...hreadid=487114



  #8  
Old January 10th, 2006, 06:46 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Y-Axis Label


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


--
whistles28
------------------------------------------------------------------------
whistles28's Profile: http://www.excelforum.com/member.php...o&userid=30317
View this thread: http://www.excelforum.com/showthread...hreadid=487114

  #9  
Old January 30th, 2006, 03:41 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Y-Axis Label

Francisco -

Thanks for the suggestion.

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

"whistles28" wrote
in message ...

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


--
whistles28
------------------------------------------------------------------------
whistles28's Profile:
http://www.excelforum.com/member.php...o&userid=30317
View this thread: http://www.excelforum.com/showthread...hreadid=487114



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Text is missing along the vertical axis of the chart (Y label) BillAustralia Charts and Charting 1 January 10th, 2006 06:53 PM
Text Truncated on Vertical Chart Axis Label Adrian General Discussion 1 October 20th, 2005 11:50 AM
Label x axis on very long spreadsheet ah Charts and Charting 4 August 21st, 2005 03:46 PM
Label SRIT General Discussion 2 June 22nd, 2004 09:42 PM
X Axis Category Label not appearing Janna Charts and Charting 0 February 13th, 2004 10:41 PM


All times are GMT +1. The time now is 08:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.