Change chart labels, titles, and other text
Most chart text — such as category axis labels, data series names, legend text, and data labels — is linked to the cells on the datasheet used to create the chart. If you edit the text of these items on the chart, they are no longer linked to the datasheet cells. To change the text of these items and maintain links to datasheet cells, edit the text on the datasheet.
Change category axis labels, data series names, or legend text