Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2007

Tip: Looking for answers? Try searching our database.

sizing pie chart category data label

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
susanhull@ou.edu - 09 Mar 2007 16:41 GMT
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.
Pete_UK - 09 Mar 2007 17:43 GMT
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

On Mar 9, 4:41 pm, susanh...@ou.edu wrote:
> 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.
susanhull@ou.edu - 09 Mar 2007 21:10 GMT
> 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
[quoted text clipped - 13 lines]
>
> - 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.
Pete_UK - 09 Mar 2007 23:37 GMT
Thanks for feeding back, Susan - glad you got it to work.

Pete

On Mar 9, 9:10 pm, susanh...@ou.edu wrote:

> > 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
[quoted text clipped - 29 lines]
>
> - Show quoted text -
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.