Chart Footer Release For Free

Check the Allow only this type of editing in the document box and select Filling in forms option. Next click Select sections to invoke the Section Protection dialog box. In that box, check only Section 1 box and click OK.

Simply double-click a header or footer to unlock it, which will allow you to edit it.

Re: Suddenly don't have access to charts (grayed out)Click on File and click on Options.On the left side click on Advanced.Scroll down to the Display options for this workbook:.Locate For objects, show:Check All.

Under Header or Footer, on the pop-up menu, select (none).Go to Insert > Header & Footer.On the top right side of the document, select Options > Remove Headers & Footers.

Edit data included in a chartClick the chart.On the Charts tab, under Data, click the arrow next to Edit, and then click Edit Data in Excel.To change the number of rows and columns that are included in the chart, rest the pointer on the lower-right corner of the selected data, and then drag to select additional data.More items...

If you click on the box below the Position, a drop-down box will appear containing the options for the position of the legend. Click Bottom. The Legend is now moved to the bottom of the chart.

Click the chart, and then click the Chart Design tab. Click Add Chart Element > Legend. To change the position of the legend, choose Right, Top, Left, or Bottom.

Edit your existing headers and footersDouble-click the header or footer you want to edit, or select Header or Footer, and then select Edit Header or Edit Footer.Add or change text for the header or footer or do any of the following:When you're done, select Close Header and Footer or press Esc.

Reason 2: Objects are hidden Within the Excel settings you can choose if objects (including charts and images) should be shown in your workbook. If this setting is set to hide all objects, you cannot insert any new objects so that the buttons are greyed-out.Scroll down to the Display options for this workbook:.

In the chart, click the title that you want to move to another location. To move the title, position the pointer on the border of the title box so that it changes to a four-headed arrow , and then drag the title box to the location that you want.