Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mancini-Small-Bus
 
Posts: n/a
Default EXCEL - Concatinated Y-axis Label

The label for the Y axis for a graphed data is character-limited.

Is there a "setting" that allows this to be expanded to display more
characters?
(I know that font size has some effect.)

Thanks

  #2   Report Post  
CyberTaz
 
Posts: n/a
Default EXCEL - Concatinated Y-axis Label

Hello-

How many characters do you need? Don't let the fact that you cannot manually
resize the label box deceive you. Just keep typing and the width & height
will increase as necessary - width to the edges of the chart sheet, height to
as many as 5 or 6 lines. The one 'buggy' issue is that the next additional
line does not display until it has a certain amount of content.

If that still doesn't get the job done, delete the Label & replace it with a
Text Box. Use the Format Properties to set vertical alignment and type in as
much text as you want. (Bonus- You can also draw the Text Box, then click in
the Formula Bar and link to any cell in the workbook to display it's content
in the box on the chart. the content of the box will update if the cell
content changes.)

Regards |:)

"Mancini-Small-Bus" wrote:

The label for the Y axis for a graphed data is character-limited.

Is there a "setting" that allows this to be expanded to display more
characters?
(I know that font size has some effect.)

Thanks

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
Excel XP - text missing when orienting z axis 90 degrees Scott Excel Discussion (Misc queries) 1 August 23rd 05 01:01 AM
axis problems in excel denise Charts and Charting in Excel 2 June 26th 05 04:18 PM
My Y-axis label is cut off in Excel charts tex_brazil Charts and Charting in Excel 1 May 26th 05 12:25 PM
How do I get a second Y axis in Excel 2000 Cathy1114 Charts and Charting in Excel 2 January 20th 05 12:58 AM
the dates to label the x axis on the scatter chart won't print waterlady Charts and Charting in Excel 0 November 29th 04 06:44 PM


All times are GMT +1. The time now is 05:49 PM.

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

About Us

"It's about Microsoft Excel"