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