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
|
|||
|
|||
axis wrap text
Hi!
When I create bar chart with relatively long lables for categories on Y (left) axis the program by default puts the label in one line. This means that sometimes half of my screen is occupied by labels (i.e. "exchange of cell phone ringtones") and the other half are the actual bars. This gets pretty annoying when I have only few categories and the labels could easily be written in 3 or even four lines. Do you have any ideas hor to force the program to write labels in "wrap text" mode? Kind regards, Sunshine P.S. Another thing that's bothering me is the default "auto scale" option for text in charts. Is there any way to turn it off? |
#2
|
|||
|
|||
axis wrap text
Hi,
First the autoscale. Right click in the chart to bring up the Format ChartArea dialog. On the font tab uncheck AutoScale. Adjusting the size of the plot area can have an affect on the wrapping of axis labels. Although the control over when and how is non existent. You can force a new line in the cell text by using ALT+ENTER. These new lines should be reflected in the axis text. Cheers Andy Sunshine wrote: Hi! When I create bar chart with relatively long lables for categories on Y (left) axis the program by default puts the label in one line. This means that sometimes half of my screen is occupied by labels (i.e. "exchange of cell phone ringtones") and the other half are the actual bars. This gets pretty annoying when I have only few categories and the labels could easily be written in 3 or even four lines. Do you have any ideas hor to force the program to write labels in "wrap text" mode? Kind regards, Sunshine P.S. Another thing that's bothering me is the default "auto scale" option for text in charts. Is there any way to turn it off? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
axis wrap text
Thank you very much for you quick and helpful response. I will try and use
the alt+enter option. About the Auto Scale: I know how to turn it off manually. But than I have to do it separately for X axis, Y axis, labels, title and so on and so on... I would like to turn it off permanently. For all text inputs, for all graphs, for all times. ))) Best regards, Sunshine "Andy Pope" wrote: Hi, First the autoscale. Right click in the chart to bring up the Format ChartArea dialog. On the font tab uncheck AutoScale. Adjusting the size of the plot area can have an affect on the wrapping of axis labels. Although the control over when and how is non existent. You can force a new line in the cell text by using ALT+ENTER. These new lines should be reflected in the axis text. Cheers Andy Sunshine wrote: Hi! When I create bar chart with relatively long lables for categories on Y (left) axis the program by default puts the label in one line. This means that sometimes half of my screen is occupied by labels (i.e. "exchange of cell phone ringtones") and the other half are the actual bars. This gets pretty annoying when I have only few categories and the labels could easily be written in 3 or even four lines. Do you have any ideas hor to force the program to write labels in "wrap text" mode? Kind regards, Sunshine P.S. Another thing that's bothering me is the default "auto scale" option for text in charts. Is there any way to turn it off? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
axis wrap text
Check the registry hack on this page:
http://peltiertech.com/Excel/Charts/FixFonts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Sunshine" wrote in message ... Thank you very much for you quick and helpful response. I will try and use the alt+enter option. About the Auto Scale: I know how to turn it off manually. But than I have to do it separately for X axis, Y axis, labels, title and so on and so on... I would like to turn it off permanently. For all text inputs, for all graphs, for all times. ))) Best regards, Sunshine "Andy Pope" wrote: Hi, First the autoscale. Right click in the chart to bring up the Format ChartArea dialog. On the font tab uncheck AutoScale. Adjusting the size of the plot area can have an affect on the wrapping of axis labels. Although the control over when and how is non existent. You can force a new line in the cell text by using ALT+ENTER. These new lines should be reflected in the axis text. Cheers Andy Sunshine wrote: Hi! When I create bar chart with relatively long lables for categories on Y (left) axis the program by default puts the label in one line. This means that sometimes half of my screen is occupied by labels (i.e. "exchange of cell phone ringtones") and the other half are the actual bars. This gets pretty annoying when I have only few categories and the labels could easily be written in 3 or even four lines. Do you have any ideas hor to force the program to write labels in "wrap text" mode? Kind regards, Sunshine P.S. Another thing that's bothering me is the default "auto scale" option for text in charts. Is there any way to turn it off? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
axis wrap text
I have this same issue. I have X-axis labels that are long and I'd like to
wrap the text of these labels so they take up less space. When I do a Alt-Enter on the text in the cell it splits the long text into two lines. But this two line format does not translate to the chart. What am I doing wrong? "Jon Peltier" wrote: Check the registry hack on this page: http://peltiertech.com/Excel/Charts/FixFonts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Sunshine" wrote in message ... Thank you very much for you quick and helpful response. I will try and use the alt+enter option. About the Auto Scale: I know how to turn it off manually. But than I have to do it separately for X axis, Y axis, labels, title and so on and so on... I would like to turn it off permanently. For all text inputs, for all graphs, for all times. ))) Best regards, Sunshine "Andy Pope" wrote: Hi, First the autoscale. Right click in the chart to bring up the Format ChartArea dialog. On the font tab uncheck AutoScale. Adjusting the size of the plot area can have an affect on the wrapping of axis labels. Although the control over when and how is non existent. You can force a new line in the cell text by using ALT+ENTER. These new lines should be reflected in the axis text. Cheers Andy Sunshine wrote: Hi! When I create bar chart with relatively long lables for categories on Y (left) axis the program by default puts the label in one line. This means that sometimes half of my screen is occupied by labels (i.e. "exchange of cell phone ringtones") and the other half are the actual bars. This gets pretty annoying when I have only few categories and the labels could easily be written in 3 or even four lines. Do you have any ideas hor to force the program to write labels in "wrap text" mode? Kind regards, Sunshine P.S. Another thing that's bothering me is the default "auto scale" option for text in charts. Is there any way to turn it off? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Newbie Looking for Help | Little Penny | Using Forms | 6 | December 27th, 2005 08:33 PM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Query for 'confirmation' | rogge | Running & Setting Up Queries | 8 | April 19th, 2005 03:26 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 |
Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |