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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |