There are a few things you need to do in order to unlock charts in Excel. First, you need to make sure that the worksheet is unprotected. To do this, go to the Review tab and click on Unprotect Sheet. If you don't see this option, it means that the sheet is already unprotected.
Once the sheet is unprotected, you can select the cells that you want to unlock. To do this, click on the cell and then press Ctrl + 1. This will bring up the Format Cells dialog box. In the Protection tab, uncheck the Locked checkbox and then click OK. The cells should now be unlocked.
You can now select the chart that you want to unlock. To do this, go to the Chart Tools tab and click on Select Data. In the Select Data Source dialog box, click on the chart data that you want to unlock and then press the Delete key. The data should now be deleted from the chart.
Get started with Causal today. Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.