I cannot make axis labels wordwrap. Legends sometimes do and sometimes don't.
The legend entries will word wrap if the entire legend is not wide enough
for a particular entry (or if you have hard-coded a carriage return in the
cell containing the legend entry text, using Alt Enter).
You have no control over axis tick labels, other than hard-coding a carriage
return in the cell containing the tick label text, using Alt Enter.
Sometimes these wrap where Excel wants them to, but you can't control the
label size.
Items like data labels and axis and chart titles can be edited, and you
insert a carriage return where you want the text to wrap. Sometimes these
wrap where Excel wants them to, but you can't control the label or title
size.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;LC673quot; gt; wrote in message
...
gt;I cannot make axis labels wordwrap. Legends sometimes do and sometimes
gt;don't.
I did this. I went into the cells and used Alt Enter to wrap my label text.
It still doesn't show on my chart. Help!!
Thank you.
Susie
quot;Jon Peltierquot; wrote:
gt; The legend entries will word wrap if the entire legend is not wide enough
gt; for a particular entry (or if you have hard-coded a carriage return in the
gt; cell containing the legend entry text, using Alt Enter).
gt;
gt; You have no control over axis tick labels, other than hard-coding a carriage
gt; return in the cell containing the tick label text, using Alt Enter.
gt; Sometimes these wrap where Excel wants them to, but you can't control the
gt; label size.
gt;
gt; Items like data labels and axis and chart titles can be edited, and you
gt; insert a carriage return where you want the text to wrap. Sometimes these
gt; wrap where Excel wants them to, but you can't control the label or title
gt; size.
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;
gt; quot;LC673quot; gt; wrote in message
gt; ...
gt; gt;I cannot make axis labels wordwrap. Legends sometimes do and sometimes
gt; gt;don't.
gt;
gt;
gt;
- Mar 13 Thu 2008 20:43
How do I make chart labels or legends wordwrap?
close
全站熱搜
留言列表
發表留言