Forum Discussion
How to prevent chart (plot area) from drag and drop?
In the excel sheet, I am creating a chart. I can make chart poistion independent by > Format Chart Area > Properties > Don't move or size with cells. However it is preventing automatically resizi...
R.Click on "chart area"
"Format Chart Area"
Choose "Size & Properties"
Check "Locked"
Then R.Click the Sheet that containing the chart
Choose "Protect Sheet…"
Make sure the option "Edit objects" is Unchecked.
Hope it dose work with you.
No, I dont want to protect sheet. Somebody should be able to edit and also shouldn't be able to drag it. I am looking for options other than protect.