do not allow moving/selecting/editing pivot chart but allow the user to use the filters of the pivot chart

[orfeas]

Hello everybody,

i have a chart (created from a pivot table) and i want the user to be able to use the filter on the chart but to NOT be able to edit, copy or move the chart.
Is this possible??

 

[sijpie]

See these threads:

How to Protect a sheet but still interact with PivotCharts and Slicers

So I created a sheet of PivotCharts (PivotTables are on another hidden sheet) and want to protect it so that the charts and their layout cannot be affected, however I wish to retain the ability to ...

stackoverflow.com

Allow selecting but not editing a chart and slicers in a protected Excel sheet

I would like to share an excel file that has slicers and charts in it. I want users to be able to use the slicers for filtering and then select and copy the charts. But I want to protect the sheet ...

superuser.com

 

[orfeas]

unfortunately these links do not give the correct answer