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

JenniferMurphy

Well-known Member
Joined
Jul 23, 2011
Messages
1,584
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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

JenniferMurphy

Well-known Member
Joined
Jul 23, 2011
Messages
1,584
Office Version
  1. 365
Platform
  1. Windows
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.
 

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
12,979
Office Version
  1. 2013
Platform
  1. Windows
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.
 
Solution

JenniferMurphy

Well-known Member
Joined
Jul 23, 2011
Messages
1,584
Office Version
  1. 365
Platform
  1. Windows
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:
 

Forum statistics

Threads
1,141,815
Messages
5,708,740
Members
421,588
Latest member
Wawie

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
Top