Most chart text — such as category axis labels (tick marks and tick-mark labels: Tick marks are small lines of measurement, similar to divisions on a ruler, that intersect an axis. Tick-mark labels identify the categories, values, or series in the chart.), data series (data series: Related data points that are plotted in a chart and originate from datasheet rows or columns. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series.) names, legend (legend: A box that identifies the patterns or colors that are assigned to the data series or categories in a chart.) text, and data labels (data label: A label that provides additional information about a data marker, which represents a single data point or value that originates from a datasheet cell.) — 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
Change data labels
Edit chart and axis titles