Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Unable to change label box size in Excel


(!)

dmcclure's Avatar
dmcclure dmcclure is offline
Member with 142 posts.
THREAD STARTER
 
Join Date: Jul 1999
Location: Port Townsend, WA
19-Mar-2007, 07:12 PM #1
Solved: Unable to change label box size in Excel
I'm tgrying to resize a data point label in an Excel chart. (Excel 2002) According to the Excel help file:

"Click the chart area, the plot area, or the legend you want to move or resize.
To move an item, point to the item, and then drag it to another location.
To resize an item, point to a sizing handle. When the pointer changes to a double-headed arrow, drag the sizing handle until the item is the size you want."

I'm used to doing this in lots of other programs but I can't get it to work in my Excel charts. Does that mean I cannot resize data point data labels in Excel?

Don
jnoonananster's Avatar
jnoonananster jnoonananster is offline
Computer Specs
Junior Member with 2 posts.
 
Join Date: May 2007
Experience: Advanced
09-May-2007, 04:20 PM #2
Same problem..
Don, I have the same problem and have been trying to solve it for two weeks now. I can't find any answers. Someone please help!!!
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
10-May-2007, 12:38 AM #3
Can either of you two upload a sample file please?

And jnoonananster, welcome to the board!
dmcclure's Avatar
dmcclure dmcclure is offline
Member with 142 posts.
THREAD STARTER
 
Join Date: Jul 1999
Location: Port Townsend, WA
10-May-2007, 09:14 AM #4
Hi - Thanks for the offer to review the file. However, it's been a couple of months since posted the problem and I can't remember what spreadsheet I was working on then. I guess I found a way to work around the problem or it went away on it's own!

Don
jnoonananster's Avatar
jnoonananster jnoonananster is offline
Computer Specs
Junior Member with 2 posts.
 
Join Date: May 2007
Experience: Advanced
10-May-2007, 10:29 AM #5
Here's an example
It's not the hugest deal in the world, but I would like to have control over the size (width and height) of the label boxes. I have been able to edit the text inside (font and size, breaks), but the set bounding box is a real limitation regardless. Thanks for taking a look.
Attached Files
File Type: zip example_resizelabels.zip (67.6 KB, 299 views)
slurpee55's Avatar
Computer Specs
Member with 7,837 posts.
 
Join Date: Oct 2004
Location: Southwest Iowa....
Experience: Currently stupid...
10-May-2007, 11:02 AM #6
Jnoonananster, to start with,you file is in PowerPoint, not Excel, so the pictures you have are Metafiles - a type of picture, You probably originally made them in Excel or based them on an Excel spreadsheet. If you want to edit the labels for them, I think you have to do it in the original graph, not the picture copied into PowerPoint.
dmcclure's Avatar
dmcclure dmcclure is offline
Member with 142 posts.
THREAD STARTER
 
Join Date: Jul 1999
Location: Port Townsend, WA
11-May-2007, 11:16 AM #7
I found the file that started all this and I've attached it. I cannot change the data point label box. For example: see the data point labeled " Fences/gravel/mailboxes 8%". I'd like to increase the width so "Fences/gravel/mailboxes" all fits on one line.

Don
Attached Files
File Type: xls qqq.xls (27.0 KB, 245 views)
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
11-May-2007, 01:11 PM #8
I'm afraid you cannot edit/change those. You cannot even do this programmatically through VBA. you can, however, replace it with a standard textbox and have the ability to resize it, but then you also lose the native ability to have it linked to your chart [location]. Sorry.
dmcclure's Avatar
dmcclure dmcclure is offline
Member with 142 posts.
THREAD STARTER
 
Join Date: Jul 1999
Location: Port Townsend, WA
11-May-2007, 08:25 PM #9
Well - That's sorta dumb! Maybe in Excel 2025 they'll fix that.
Thanks for the answer.

Don
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑