Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Amy Amy is offline
external usenet poster
 
Posts: 165
Default Spaces in y-axis title

I am having trouble getting some y-axis titles to display correctly. If I
have either a Greek letter (symbol font) or a superscript number as part of
the axis title, an unwanted space appears immediately before this character.
This is not an actual space character like that created with the space bar,
because when I click on the axis title to edit it (so that it temporarily
appears horizontally), the space disappears so that I can't delete it. The
unwanted space comes back as soon as the axis title goes back to its normal
rotated position when I finish editing it.

The axis title looks the same both on the screen and when printed, so I
doubt it is due to screen resolution settings mentioned in some posts
referring to other axis title problems.

I'm using Excel 2003.

Thanks for any suggestions.
  #3   Report Post  
Posted to microsoft.public.excel.charting
Amy Amy is offline
external usenet poster
 
Posts: 165
Default Spaces in y-axis title

Thanks Tushar - I actually tried this and still got the same problem. After
doing some more playing around it seems that the problem is worse if the axis
title is fairly long - the unwanted space isn't noticeable if the axis title
is only a few characters long (this applies to both a y-axis title and a text
box with the text rotated - but doesn't happen with horizontal text in a text
box). However, if I break my axis title over two lines, the problem doesn't
seem to happen - so I guess that's what I'll have to do unless anyone has any
other suggestions.

Maybe this is a bug? Has anyone else experienced this?


"Tushar Mehta" wrote:

My usual substitute for chart-based text-type boxes (such as chart title,
axis title, etc.) is to simply add a textbox of my own. Select the chart
then from the Drawing toolbar select and add a textbox. Better formatting
and position control.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I am having trouble getting some y-axis titles to display correctly. If I
have either a Greek letter (symbol font) or a superscript number as part of
the axis title, an unwanted space appears immediately before this character.
This is not an actual space character like that created with the space bar,
because when I click on the axis title to edit it (so that it temporarily
appears horizontally), the space disappears so that I can't delete it. The
unwanted space comes back as soon as the axis title goes back to its normal
rotated position when I finish editing it.

The axis title looks the same both on the screen and when printed, so I
doubt it is due to screen resolution settings mentioned in some posts
referring to other axis title problems.

I'm using Excel 2003.

Thanks for any suggestions.


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
I could NOT resize the axis title but excel allows me to resize gr Iwan Setiyono Ko Charts and Charting in Excel 4 June 6th 06 04:46 AM
My Y axis title in my charts run together Otyokwa Charts and Charting in Excel 0 April 19th 06 06:43 PM
I could NOT resize the axis title but excel allows me to resize gr Iwan Setiyono Ko Charts and Charting in Excel 0 March 15th 06 10:34 AM
Why do I not see the whole axis title in Excel? Jennybr Charts and Charting in Excel 1 November 22nd 05 01:09 PM
Pasting Objects into Chart title and Axis title Sam Charts and Charting in Excel 1 June 6th 05 08:50 PM


All times are GMT +1. The time now is 05:50 AM.

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"