how to increase area of Y axis title, so full text will be shown?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
dancho79 said:
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!
 
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/
_______
 
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/
_______
 
Back
Top