Add Chart Title For Free

The title should concisely tell the reader what is in the graph. Avoid the obvious use of ?vs.? or ?versus? or the word ?plotted? in the title. Graphs that will appear as a figure in a publication or in a formal laboratory report will not have a title (the information is given in the figure caption).

Use a Header Click the ?Insert? tab. Click the ?Header & Footer? button on the ribbon. The spreadsheet zooms out slightly and the ?Click to add header? text box opens at the top of the spreadsheet. Click into the text box and type the spreadsheet title.

Click the chart to select it. In the Format sidebar, click the Chart tab, then select the Title tickbox. Double-click the placeholder title on the chart and type your own.

Make a dynamic chart title Click on the chart title. Type the equal sign (=) in the Formula bar. When you type in the equal sign, please, make sure that it is in the Formula bar, not in the title box. Click on the cell that you want to link to the chart title. ... Press the Enter button.

To insert a text box, click the Insert ribbon and click the Text Box icon on the far right. Then use the mouse to draw the text box above the sheet grid. To link a text box to a cell, have the text box selected, click in the Formula Bar and press = and then click the cell to link to and press Enter ? see Figure 02.

Follow these steps to do so: Click the "Insert" tab. Select the "Insert" tab from the top menu. ... Choose "Header & Footer" Select "Header & Footer" from the top menu. ... Select the header and add a title. Click on the newly added header at the top of the sheet.

To add a data label to your chart, click on the data point you want to label, then press Ctrl + 1. This shortcut will open the Format Data Labels dialog box, where you can choose how you want your data label to look. 5. To add a title to your chart, click on the chart, then press Ctrl + Shift + T.