software

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. quot;exchange of
cell phone ringtonesquot;) 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 quot;wrap
textquot; mode?

Kind regards,
Sunshine

P.S. Another thing that's bothering me is the default quot;auto scalequot; option
for text in charts. Is there any way to turn it off?

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:
gt; Hi!
gt;
gt; When I create bar chart with relatively long lables for categories on Y
gt; (left) axis the program by default puts the label in one line. This means
gt; that sometimes half of my screen is occupied by labels (i.e. quot;exchange of
gt; cell phone ringtonesquot;) and the other half are the actual bars. This gets
gt; pretty annoying when I have only few categories and the labels could easily
gt; be written in 3 or even four lines.
gt;
gt; Do you have any ideas hor to force the program to write labels in quot;wrap
gt; textquot; mode?
gt;
gt; Kind regards,
gt; Sunshine
gt;
gt; P.S. Another thing that's bothering me is the default quot;auto scalequot; option
gt; for text in charts. Is there any way to turn it off?

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

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

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; First the autoscale. Right click in the chart to bring up the Format
gt; ChartArea dialog. On the font tab uncheck AutoScale.
gt;
gt; Adjusting the size of the plot area can have an affect on the wrapping
gt; of axis labels. Although the control over when and how is non existent.
gt; You can force a new line in the cell text by using ALT ENTER. These new
gt; lines should be reflected in the axis text.
gt;
gt; Cheers
gt; Andy
gt;
gt; Sunshine wrote:
gt; gt; Hi!
gt; gt;
gt; gt; When I create bar chart with relatively long lables for categories on Y
gt; gt; (left) axis the program by default puts the label in one line. This means
gt; gt; that sometimes half of my screen is occupied by labels (i.e. quot;exchange of
gt; gt; cell phone ringtonesquot;) and the other half are the actual bars. This gets
gt; gt; pretty annoying when I have only few categories and the labels could easily
gt; gt; be written in 3 or even four lines.
gt; gt;
gt; gt; Do you have any ideas hor to force the program to write labels in quot;wrap
gt; gt; textquot; mode?
gt; gt;
gt; gt; Kind regards,
gt; gt; Sunshine
gt; gt;
gt; gt; P.S. Another thing that's bothering me is the default quot;auto scalequot; option
gt; gt; for text in charts. Is there any way to turn it off?
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;

Check the registry hack on this page:

peltiertech.com/Excel/Charts/FixFonts.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;Sunshinequot; gt; wrote in message
...
gt; Thank you very much for you quick and helpful response. I will try and use
gt; the alt enter option.
gt;
gt; About the Auto Scale: I know how to turn it off manually. But than I have
gt; to
gt; do it separately for X axis, Y axis, labels, title and so on and so on...
gt; I
gt; would like to turn it off permanently. For all text inputs, for all
gt; graphs,
gt; for all times. )))
gt;
gt; Best regards,
gt; Sunshine
gt;
gt; quot;Andy Popequot; wrote:
gt;
gt;gt; Hi,
gt;gt;
gt;gt; First the autoscale. Right click in the chart to bring up the Format
gt;gt; ChartArea dialog. On the font tab uncheck AutoScale.
gt;gt;
gt;gt; Adjusting the size of the plot area can have an affect on the wrapping
gt;gt; of axis labels. Although the control over when and how is non existent.
gt;gt; You can force a new line in the cell text by using ALT ENTER. These new
gt;gt; lines should be reflected in the axis text.
gt;gt;
gt;gt; Cheers
gt;gt; Andy
gt;gt;
gt;gt; Sunshine wrote:
gt;gt; gt; Hi!
gt;gt; gt;
gt;gt; gt; When I create bar chart with relatively long lables for categories on Y
gt;gt; gt; (left) axis the program by default puts the label in one line. This
gt;gt; gt; means
gt;gt; gt; that sometimes half of my screen is occupied by labels (i.e. quot;exchange
gt;gt; gt; of
gt;gt; gt; cell phone ringtonesquot;) and the other half are the actual bars. This
gt;gt; gt; gets
gt;gt; gt; pretty annoying when I have only few categories and the labels could
gt;gt; gt; easily
gt;gt; gt; be written in 3 or even four lines.
gt;gt; gt;
gt;gt; gt; Do you have any ideas hor to force the program to write labels in quot;wrap
gt;gt; gt; textquot; mode?
gt;gt; gt;
gt;gt; gt; Kind regards,
gt;gt; gt; Sunshine
gt;gt; gt;
gt;gt; gt; P.S. Another thing that's bothering me is the default quot;auto scalequot;
gt;gt; gt; option
gt;gt; gt; for text in charts. Is there any way to turn it off?
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Andy Pope, Microsoft MVP - Excel
gt;gt; www.andypope.info
gt;gt;
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?

quot;Jon Peltierquot; wrote:

gt; Check the registry hack on this page:
gt;
gt; peltiertech.com/Excel/Charts/FixFonts.html
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Sunshinequot; gt; wrote in message
gt; ...
gt; gt; Thank you very much for you quick and helpful response. I will try and use
gt; gt; the alt enter option.
gt; gt;
gt; gt; About the Auto Scale: I know how to turn it off manually. But than I have
gt; gt; to
gt; gt; do it separately for X axis, Y axis, labels, title and so on and so on...
gt; gt; I
gt; gt; would like to turn it off permanently. For all text inputs, for all
gt; gt; graphs,
gt; gt; for all times. )))
gt; gt;
gt; gt; Best regards,
gt; gt; Sunshine
gt; gt;
gt; gt; quot;Andy Popequot; wrote:
gt; gt;
gt; gt;gt; Hi,
gt; gt;gt;
gt; gt;gt; First the autoscale. Right click in the chart to bring up the Format
gt; gt;gt; ChartArea dialog. On the font tab uncheck AutoScale.
gt; gt;gt;
gt; gt;gt; Adjusting the size of the plot area can have an affect on the wrapping
gt; gt;gt; of axis labels. Although the control over when and how is non existent.
gt; gt;gt; You can force a new line in the cell text by using ALT ENTER. These new
gt; gt;gt; lines should be reflected in the axis text.
gt; gt;gt;
gt; gt;gt; Cheers
gt; gt;gt; Andy
gt; gt;gt;
gt; gt;gt; Sunshine wrote:
gt; gt;gt; gt; Hi!
gt; gt;gt; gt;
gt; gt;gt; gt; When I create bar chart with relatively long lables for categories on Y
gt; gt;gt; gt; (left) axis the program by default puts the label in one line. This
gt; gt;gt; gt; means
gt; gt;gt; gt; that sometimes half of my screen is occupied by labels (i.e. quot;exchange
gt; gt;gt; gt; of
gt; gt;gt; gt; cell phone ringtonesquot;) and the other half are the actual bars. This
gt; gt;gt; gt; gets
gt; gt;gt; gt; pretty annoying when I have only few categories and the labels could
gt; gt;gt; gt; easily
gt; gt;gt; gt; be written in 3 or even four lines.
gt; gt;gt; gt;
gt; gt;gt; gt; Do you have any ideas hor to force the program to write labels in quot;wrap
gt; gt;gt; gt; textquot; mode?
gt; gt;gt; gt;
gt; gt;gt; gt; Kind regards,
gt; gt;gt; gt; Sunshine
gt; gt;gt; gt;
gt; gt;gt; gt; P.S. Another thing that's bothering me is the default quot;auto scalequot;
gt; gt;gt; gt; option
gt; gt;gt; gt; for text in charts. Is there any way to turn it off?
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Andy Pope, Microsoft MVP - Excel
gt; gt;gt; www.andypope.info
gt; gt;gt;
gt;
gt;
gt;