sizing pie chart category data label

S

susanhull

I would appreciate advice on re-sizing pie chart category data labels.
When I click on the label, I get a box around the text, just like
other microsoft applications, but when I click and drag on the points,
the text label box does not re-size...it stays the same size. Any
suggestions? Thank you.
 
P

Pete_UK

I think it auto-adjusts to suit the font-size and text that you have
in there. Try right-clicking on the label, then you usually have
access to other features.

Hope this helps.

Pete
 
S

susanhull

I think it auto-adjusts to suit the font-size and text that you have
in there. Try right-clicking on the label, then you usually have
access to other features.

Hope this helps.

Pete



- Show quoted text -

Thanks for your comments, Pete.

The label box does adjust automatically, but not gracefully. I was
left with a word whose last letter wrapped to the next line, and
adjusting the font left me with options equally as goofy. I did more
research and found a solution. Thought I'd share for others.
Apparently, in Excel version 2003 the data labels do not expand as in
other Microsoft software. But one can create a text box that can be
sized. To create the text box, click on the pie chart that has been
created, press the "=" key, then point and click the Excel cell that
holds your text. A text box will appear in the middle of your chart,
and it will contain the contents of the original cell (including font
size, etc.) The label box can be moved anywhere and resized.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top