In PivotChart reports, the following procedures reestablish links between data labels and source data (not worksheet cells). On a chart, click the chart or axis title that you want to link to a corresponding worksheet cell. On the worksheet, click in the formula bar, and then type an equal sign (=). More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.