Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
D. Bishop
 
Posts: n/a
Default Anomaly with Chart Labels

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
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

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" wrote in message
...
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
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
XL Chart: Separately align series and value data labels Stuart Bratesman Charts and Charting in Excel 3 August 10th 05 11:07 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
How do I not include empty cell value chart labels in pie charts? JMarble Charts and Charting in Excel 1 May 13th 05 08:38 PM
How do I get my data labels on a pivot chart to retain their form. s de maia Charts and Charting in Excel 1 March 18th 05 03:34 AM
how can I fill labels in a chart, so that the grid lines don't in. peterk Charts and Charting in Excel 2 February 18th 05 01:52 AM


All times are GMT +1. The time now is 03:28 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"