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

[dancho79]

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!

[Bernard Liengme]

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" <[email protected]> wrote in message
news:[email protected]...
> 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!

[dancho79]

"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!

[Jon Peltier]

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!

[dancho79]

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!
>

[Jon Peltier]

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!
>>

[dancho79]

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!
> >>
>