Unlock Chart Text For Free

In Word, click where you want to insert the chart. On the Insert tab, in the Illustrations group, click Chart. In the Insert Chart dialog box, click a chart, and then click OK. Enter your data into the spreadsheet that automatically opens with the chart.

On the Home tab, click the Format Cell Font popup launcher. You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells popup, in the Protection tab, uncheck the Locked box and then click OK. This unlocks all the cells on the worksheet when you protect the worksheet.

Insert a text box on a chart Click the chart to which you want to add a text box. On the Format tab, click Insert Shapes, and then click the Text Box icon . In the chart, click where you want to start a corner of the text box, and then drag until the text box is the size that you want.

Add data labels Click the chart, and then click the Chart Design tab. Click Add Chart Element and select Data Labels, and then select a location for the data label option. Note: The options will differ depending on your chart type. If you want to show your data label inside a text bubble shape, click Data Callout.

Create a chart Click anywhere in the data for which you want to create a chart. ... Select Insert > Charts > and the chart type you want. On the menu that opens, select the option you want. ... To edit the chart (titles, legends, data labels), select the Chart tab and then select Format.

With the text box selected, choose Text Box>Position>More Layout Options and check the Lock anchor option. This will keep the text box anchored to the paragraph at the top of the page. If the paragraph at the top of the page moves to another page, the text box will move with it.

Step 1? Select the cell in the worksheet from which you need to remove the data value restriction. Step 2? Click Data Validation under Data > Data Tools. Step 3? Click Clear All under the Settings Tab of the dialog box as shown below. If you want to remove the similar data restriction from all other cells.