You can link textboxes, data labels, axis titles, and the chart title to any
cell in a worksheet. Select the text object, then click in the formula bar,
type =, then click on the cell. The formula bar will show a link formula to
the cell, like =Sheet1!$A$1. When you press enter, the text element becomes
linked to the contents of the cell.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"me@rrc" wrote in message
...
Thanks for update & confirmation. I can quit trying to change them now.
This is what I thought about the labels after fighting with them for so
long, but I was hoping maybe someone knew of a way into the program to do
this.
Too bad Microsoft wouldn't fix these problems, rather than giving us more
useless "bells & whistles".
Quattro (WordPerfect) doesn't do any better, but people keep telling me
office is so much better.
The text box eliminates changes to the data & the people I am teaching
will
probably forget to edit & change the text box too.
Someone mentioned linking the data to the text box. Do you know how that
would work?
me@rrc
"Jon Peltier" wrote:
The label width is controlled only by Excel, and you can't do much about
it.
You could use a textbox instead, but it will not move with the pie wedge.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"me@rrc" wrote in message
...
In EXCEL 2003 (but all versions have given this problem)
When making a pie chart with long label names & especially when
including
other data, (%, & values) the names wrap part to next line.
Is there a fix to make the label box wider?