Chart pieces instability

M

masonc

Is there any way to lock the stuff (labels, arrows, etc.) so that they
stay in position?

Mine are forever getting jiggled about and have to be re-positioned
one-by-one. (I know that moving the chart causes this, but...)

For my purpose I don't see any point in locking the whole sheet.

Thanks
 
D

Don Guillett Excel MVP

Is there any way to lock the stuff (labels, arrows, etc.) so that they
stay in position?  

Mine are forever getting jiggled about and have to be re-positioned
one-by-one.  (I know that moving the chart causes this, but...)

For my purpose I don't see any point in locking the whole sheet.

  Thanks
Click to expand...

depending on version, right click chart/shape>format>properties>>>>
 
M

masonc

depending on version, right click chart/shape>format>properties>>>>
Click to expand...

Excel 2003 SP3 and I cannot find "chart/shape format properties"
It appears that the whole sheet must be locked -- this is besides
the point of objects moving about on the chart when the chart is
moved on the sheet. I'm trying "Format chart area > Properties >
Move and size with cells" rather than "Don't move..."
 
Top