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?

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?

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?

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?

Thanks, I have linked other data for marks & names, & this now makes it
possible to create better charts. Works well.

"Jon Peltier" wrote:

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?

woo... this is excellent. I didn't know a text box can link to cell.

But it is not able to put in formula like "=roundup(A1,0)", right?

"Jon Peltier" wrote:

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?

On Fri, 20 Jul 2007, in microsoft.public.excel.charting,
Angus said:

woo... this is excellent. I didn't know a text box can link to cell.

But it is not able to put in formula like "=roundup(A1,0)", right?

Correct. But you can link to a cell that does have that formula, and
that's just as good.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.