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?

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" <me@rrc@discussions.microsoft.com> wrote in message
news:A5CB0CD7-18A0-4D88-9793-C774E986D583@microsoft.com...
> 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" <me@rrc@discussions.microsoft.com> wrote in message
> news:A5CB0CD7-18A0-4D88-9793-C774E986D583@microsoft.com...
> > 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" <merrc@discussions.microsoft.com> wrote in message
news:7219B730-5CA5-4FC0-A35D-6FAF41521E2A@microsoft.com...
> 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" <me@rrc@discussions.microsoft.com> wrote in message
>> news:A5CB0CD7-18A0-4D88-9793-C774E986D583@microsoft.com...
>> > 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" <merrc@discussions.microsoft.com> wrote in message
> news:7219B730-5CA5-4FC0-A35D-6FAF41521E2A@microsoft.com...
> > 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" <me@rrc@discussions.microsoft.com> wrote in message
> >> news:A5CB0CD7-18A0-4D88-9793-C774E986D583@microsoft.com...
> >> > 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" <merrc@discussions.microsoft.com> wrote in message
> news:7219B730-5CA5-4FC0-A35D-6FAF41521E2A@microsoft.com...
> > 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" <me@rrc@discussions.microsoft.com> wrote in message
> >> news:A5CB0CD7-18A0-4D88-9793-C774E986D583@microsoft.com...
> >> > 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 <Angus@discussions.microsoft.com> 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 del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.