Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
dancho79
 
Posts: n/a
Default how to increase area of Y axis title, so full text will be shown?

in X-Y scatter chart i am having problem of text fitting the title box of Y
axis title. Neither I can increase it manually, not through clicking menus.
Any option to do so is absent. Is there any way i can increse text box? thank
you!
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default how to increase area of Y axis title, so full text will be shown?

Give chart a dummy tile when you make the chart.
Type the real title into a cell using ALT+ENTER to use multiple lines
Click chart title and in formula box type =, point to the cell with the long
title
done
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dancho79" wrote in message
...
in X-Y scatter chart i am having problem of text fitting the title box of
Y
axis title. Neither I can increase it manually, not through clicking
menus.
Any option to do so is absent. Is there any way i can increse text box?
thank
you!



  #3   Report Post  
dancho79
 
Posts: n/a
Default how to increase area of Y axis title, so full text will be shown?



"dancho79" wrote:

in X-Y scatter chart i am having problem of text fitting the title box of Y
axis title. Neither I can increase it manually, not through clicking menus.
Any option to do so is absent. Is there any way i can increse text box? thank
you!


i tried it, but still box is too small to contain whole title. regards!
  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default how to increase area of Y axis title, so full text will be shown?

Use a textbox instead of the default title. Some combinations of Excel
and Windows versions, monitor aspect ratio, display zoom, and phase of
the moon causes the Y axis title to be truncated. I've tried to help
sort it out, but it's larger and more sporadic than I can get a handle on.

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

dancho79 wrote:


"dancho79" wrote:


in X-Y scatter chart i am having problem of text fitting the title box of Y
axis title. Neither I can increase it manually, not through clicking menus.
Any option to do so is absent. Is there any way i can increse text box? thank
you!



i tried it, but still box is too small to contain whole title. regards!

  #5   Report Post  
dancho79
 
Posts: n/a
Default how to increase area of Y axis title, so full text will be sho

ye, i tried it. it's shown on the graph, but not coming out of printer...

"Jon Peltier" wrote:

Use a textbox instead of the default title. Some combinations of Excel
and Windows versions, monitor aspect ratio, display zoom, and phase of
the moon causes the Y axis title to be truncated. I've tried to help
sort it out, but it's larger and more sporadic than I can get a handle on.

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

dancho79 wrote:


"dancho79" wrote:


in X-Y scatter chart i am having problem of text fitting the title box of Y
axis title. Neither I can increase it manually, not through clicking menus.
Any option to do so is absent. Is there any way i can increse text box? thank
you!



i tried it, but still box is too small to contain whole title. regards!




  #6   Report Post  
Jon Peltier
 
Posts: n/a
Default how to increase area of Y axis title, so full text will be sho

Usually it's truncated on screen, but it's okay in print preview and off
the printer. Hmm, you may need to install new printer drivers.

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


dancho79 wrote:
ye, i tried it. it's shown on the graph, but not coming out of printer...

"Jon Peltier" wrote:


Use a textbox instead of the default title. Some combinations of Excel
and Windows versions, monitor aspect ratio, display zoom, and phase of
the moon causes the Y axis title to be truncated. I've tried to help
sort it out, but it's larger and more sporadic than I can get a handle on.

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

dancho79 wrote:


"dancho79" wrote:



in X-Y scatter chart i am having problem of text fitting the title box of Y
axis title. Neither I can increase it manually, not through clicking menus.
Any option to do so is absent. Is there any way i can increse text box? thank
you!


i tried it, but still box is too small to contain whole title. regards!


  #7   Report Post  
dancho79
 
Posts: n/a
Default how to increase area of Y axis title, so full text will be sho

i will try to reinstall driver and see what will happen. thanks!

"Jon Peltier" wrote:

Usually it's truncated on screen, but it's okay in print preview and off
the printer. Hmm, you may need to install new printer drivers.

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


dancho79 wrote:
ye, i tried it. it's shown on the graph, but not coming out of printer...

"Jon Peltier" wrote:


Use a textbox instead of the default title. Some combinations of Excel
and Windows versions, monitor aspect ratio, display zoom, and phase of
the moon causes the Y axis title to be truncated. I've tried to help
sort it out, but it's larger and more sporadic than I can get a handle on.

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

dancho79 wrote:


"dancho79" wrote:



in X-Y scatter chart i am having problem of text fitting the title box of Y
axis title. Neither I can increase it manually, not through clicking menus.
Any option to do so is absent. Is there any way i can increse text box? thank
you!


i tried it, but still box is too small to contain whole title. regards!


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
How can I calculate the area between axis and dataseries xl2002 Evert Excel Discussion (Misc queries) 4 September 28th 05 04:09 PM
Display Text in the Data Area of a Pivot Table Wayne Wilmeth Excel Discussion (Misc queries) 0 August 4th 05 10:12 PM
Excel chart-y axis title question springwinterfall Excel Discussion (Misc queries) 6 July 18th 05 02:27 PM
How do I move the Category Axis labels outside of the Plot Area? Brian Shoun Charts and Charting in Excel 1 January 7th 05 05:42 PM
How to change the Excel Title Bar to show the full file path na... lmilkey8855 Excel Discussion (Misc queries) 2 January 6th 05 03:08 PM


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