Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
LC673
 
Posts: n/a
Default How do I make chart labels or legends wordwrap?

I cannot make axis labels wordwrap. Legends sometimes do and sometimes don't.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
SusieQInOregon
 
Posts: n/a
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pie-in-Pie (sort of) how can I make this chart? KR Charts and Charting in Excel 1 June 10th 05 12:35 PM
How do I get my data labels on a pivot chart to retain their form. s de maia Charts and Charting in Excel 1 March 18th 05 03:34 AM
how can I fill labels in a chart, so that the grid lines don't in. peterk Charts and Charting in Excel 2 February 18th 05 01:52 AM
Make a pie chart of a budget Zoddious Charts and Charting in Excel 1 December 30th 04 01:15 AM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM


All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"