If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
axis title text box is wrong size in chart for excel 2003 | hey_scott | Charts and Charting | 3 | February 16th, 2006 12:25 AM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
Help with design | Ronnie | Database Design | 6 | March 12th, 2005 02:53 PM |
Access reports with a horizontal line after each record??? | Bill via AccessMonster.com | Setting Up & Running Reports | 6 | March 9th, 2005 04:51 PM |