how to change width of label box in pie chart

[Guest]

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?

 

[Jon Peltier]

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

 

[Guest]

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]

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

 

[Guest]

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

 

[Guest]

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?

 

[Del Cotter]

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.