Feb 13 2021 11:45 AM
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 resizing according to the columns.
But what I want is,
I still can be able to move (drag and drop) the chart/plot area through out the excel. How can make chart area position fixed to particular area/columns, So that it can't be moved once its position is fixed.
Feb 15 2021 03:02 AM
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.
Feb 15 2021 07:04 AM - edited Feb 15 2021 07:13 AM
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.