Tag Chart Deed For Free

To edit the contents of a title, click the chart or axis title that you want to change. To edit the contents of a data label, click two times on the data label that you want to change. The first click selects the data labels for the whole data series, and the second click selects the individual data label.

In the formula bar, type an equal sign (=). In the worksheet, select the cell that contains the data that you want to display in the title, label, or text box on the chart. Press ENTER.

On a chart, click the chart title or axis title that you want to reposition. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Format tab, in the Current Selection group, click Format Selection. In the Format Chart Title dialog box, click the Alignment category.

Click on the Chart Title box. Go to Formula bar and type = Select the cell that you want to show as the chart title. Hit Enter.

Right-click the category labels you want to change, and click Select Data. In the Horizontal (Category) Axis Labels box, click Edit. In the Axis label range box, enter the labels you want to use, separated by commas.

Add a chart title manually Click anywhere in the chart to which you want to add a title. ... On the Layout tab, in the Labels group, click Chart Title. Click Centered Overlay Title or Above Chart. In the Chart Title text box that appears in the chart, type the text that you want.

In the worksheet, click the cell that contains the title or data label text that you want to change. Edit the existing contents, or type the new text or value, and then press ENTER. The changes you made automatically appear on the chart.