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
|
|||
|
|||
How do I make chart labels or legends wordwrap?
I cannot make axis labels wordwrap. Legends sometimes do and sometimes don't.
|
#2
|
|||
|
|||
How do I make chart labels or legends wordwrap?
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" wrote in message ... I cannot make axis labels wordwrap. Legends sometimes do and sometimes don't. |
#3
|
|||
|
|||
How do I make chart labels or legends wordwrap?
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" wrote in message ... I cannot make axis labels wordwrap. Legends sometimes do and sometimes don't. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Missing x-axis labels on chart in XL97 | Rob Hick | Charts and Charting | 2 | November 18th, 2005 05:40 PM |
pasting chart shows chart area, not the chart | Pirjo | Powerpoint | 3 | October 13th, 2005 04:31 AM |
Pivot Chart - cannot save changes to data labels or page layout | Dale H | Running & Setting Up Queries | 1 | October 11th, 2005 04:59 PM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |