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 for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Excel 2007 Word 2007 Outlook 2007 PowerPoint 2007 More.

Excel 2016 chart axis labels