PC Review


Reply
Thread Tools Rate Thread

Anomaly with Chart Labels

 
 
=?Utf-8?B?RC4gQmlzaG9w?=
Guest
Posts: n/a
 
      15th Sep 2005
From what I can gather it isn't possible to resize the lables on a scatter
plot. My problem I have is that the X-axis sizes itselt correctly to display
all of the text, however, my Y-axis does not do this. Even if I put the
exact same text for both labels the Y-axis cuts the text short. Furthermore
it doesn't seem to related to the length of the text in the label. In almost
every case it is the last two letters which are cut off. I have used excel
for years and never ran into this problem. An example of the lables is shown
below. Does anyone know why this happens and if there is a way around the
problem other than using a text box to replace the label? Any help would be
appreciated

x-axis label = date of occurance : Displays = date of occurance
y-axis label = BOD (mg/L) : Displays = BOD (mg
 
Reply With Quote
 
 
 
 
Bernard Liengme
Guest
Posts: n/a
 
      20th Sep 2005
This problem has been reported by many others - but I have never seen it
with my setup.
The workaround is to add some spaces at the end of the title followed by a
period; or add some text and format it to be invisible (font
colour=background colour)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"D. Bishop" <(E-Mail Removed)> wrote in message
news:E9C0C5DE-0730-44F7-92EB-(E-Mail Removed)...
> From what I can gather it isn't possible to resize the lables on a scatter
> plot. My problem I have is that the X-axis sizes itselt correctly to
> display
> all of the text, however, my Y-axis does not do this. Even if I put the
> exact same text for both labels the Y-axis cuts the text short.
> Furthermore
> it doesn't seem to related to the length of the text in the label. In
> almost
> every case it is the last two letters which are cut off. I have used
> excel
> for years and never ran into this problem. An example of the lables is
> shown
> below. Does anyone know why this happens and if there is a way around the
> problem other than using a text box to replace the label? Any help would
> be
> appreciated
>
> x-axis label = date of occurance : Displays = date of occurance
> y-axis label = BOD (mg/L) : Displays = BOD (mg



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to change position of chart labels on line chart Shane Henderson Microsoft Excel Charting 1 27th May 2011 09:31 AM
Excel Chart auto data highlighting anomaly.... Mrpush Microsoft Excel Charting 1 23rd Nov 2009 09:54 PM
Chart labels disappear - How do I refresh the chart? =?Utf-8?B?amNsb3lkamNsb3lk?= Microsoft Excel Charting 0 30th Mar 2006 07:49 PM
Labels on a chart =?Utf-8?B?S2V2aW4=?= Microsoft Excel Charting 1 10th Feb 2005 09:16 AM
Chart labels at 90 degrees in chart do not correctly align =?Utf-8?B?UGF0cmljaWE=?= Microsoft Powerpoint 2 2nd Feb 2005 08:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:56 AM.