Chart pieces instability

[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

 

[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

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

 

[masonc]

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

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..."