Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]() "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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I calculate the area between axis and dataseries xl2002 | Excel Discussion (Misc queries) | |||
Display Text in the Data Area of a Pivot Table | Excel Discussion (Misc queries) | |||
Excel chart-y axis title question | Excel Discussion (Misc queries) | |||
How do I move the Category Axis labels outside of the Plot Area? | Charts and Charting in Excel | |||
How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) |