I cannot make axis labels wordwrap. Legends sometimes do and sometimes don't.
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
http://PeltierTech.com/
_______
"LC673" <[email protected]> wrote in message
news:[email protected]...
>I cannot make axis labels wordwrap. Legends sometimes do and sometimes
>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
"Jon Peltier" wrote:
> 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
> http://PeltierTech.com/
> _______
>
>
> "LC673" <[email protected]> wrote in message
> news:[email protected]...
> >I cannot make axis labels wordwrap. Legends sometimes do and sometimes
> >don't.
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks