The first click selects the data labels for the whole data series, and the second click selects the individual data label.Ĭlick again to place the title or data label in editing mode, drag to select the text that you want to change, type the new text or value.

To edit the contents of a data label, click two times on the data label that you want to change. To edit the contents of a title, click the chart or axis title that you want to change. Reestablish the link between a title or data label and a worksheet cell What do you want to do?Įdit the contents of a title or data label on the chartĮdit the contents of a title or data label that is linked to data on the worksheet To learn to add them, see Add or remove titles in a chart and Add or remove data labels in a chart. Note: To make any of the changes described below, a chart must already have titles or data labels.

However, you can reestablish links between titles or data labels and worksheet cells.Īfter you finish editing the text, you can move the data labels to different positions as needed. When you edit a linked title or data label on the chart (instead of within a cell), that title or data label will no longer be linked to the corresponding worksheet cell, and the changes that you make are not displayed in the worksheet itself (although you will see them on the chart).

You won't, however, be able to use rich-text formatting when you make a change from within a cell.

If, for example, you change the title in a cell from 'Yearly Revenue' to 'Annual Revenue' - that change will automatically appear in the titles and data labels on the chart. Note that you can edit titles and data labels that are linked to worksheet data in the corresponding worksheet cells. You can also edit titles and labels that are independent of your worksheet data, do so directly on the chart and use rich-text formatting to make them look better. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), you can edit those titles and labels.

Excel graph axis label text