how to change width of label box in pie chart
 

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?

how to change width of label box in pie chart
 

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?

how to change width of label box in pie chart
 

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?

how to change width of label box in pie chart
 

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?

how to change width of label box in pie chart
 

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?

how to change width of label box in pie chart
 

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?

how to change width of label box in pie chart
 

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.