The stupid text box resizing default also applies to charts (Grrr...)

JenniferMurphy

Well-known Member
Joined
Jul 23, 2011
Messages
2,687
Office Version
  1. 365
Platform
  1. Windows
The default property for text boxes is "Move and size with cells". That is, if I add, delete, or resize a row or column, any text boxes will probably get moved and/or resized.

I just discovered that this also applies to charts. I just had a very carefully and painfully crafted chart all screwed up because I moved some rows behind it. GRRRRRRRRrrrrrr.

I have 2 questions:

1. What percentage of the time do workbook authors want this behavior as opposed to the opposite, which is not to move or resize with cells? My guess is less that 5%. Maybe less than 1%. I know I NEVER want it.

2. In excel 2007, there was no way to change this default. Is there in Excel 365?

I don't have much of a problem with this being the default as long as the geniuses at M$FT provide me with an option to change it. I mean the default, not the setting for a particular object.

Thanks, and sorry for the rant. Excel is so infuriating. It's like that old sexist joke men used to say about women, that they can't live with or without them.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Look here:
I'm not sure what you mean for me to do with that. Are you suggesting some VBA code?

Right click on chart>Format Chart Area>click on dark icon, then select from menu for placement.
Yes, I know how to set it for a particular chart (or text box). My question was whether there is a way to change the default so that any new charts have it set that way.
 
Upvote 0
My question was whether there is a way to change the default so that any new charts have it set that way.

Probably not, unless you could access the application source code.
 
Upvote 0
Solution
My question was whether there is a way to change the default so that any new charts have it set that way.

Probably not, unless you could access the application source code.
Or the arrogant geniuses at M$FT could provide a default setting that any user could change. I guess that would be too user friendly. :mad:
 
Upvote 0

Forum statistics

Threads
1,223,952
Messages
6,175,589
Members
452,653
Latest member
craigje92

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top