Chart Text Elements to a Worksheet

Any text element in a chart Ccin be linked to a worksheet cell, causing the text in the worksheet to be displayed in the chart. (Some of this can be done automatically, as, for example, category labels.) But chart titles or unattached text boxes can also be linked to the worksheet. In this way titles can be generated automatically, or explanatory notes in text boxes can include information that will change as the data in the worksheet is modified. 

Basically, to link a chart text element to a worksheet cell, you enter a formula as the chart text. The syntax of the formula is  

The formula entered as chart text must be only a cell reference. If you want the chart text to be text concatenated with a number, e.g. to produce a title such as Half-wave Potential = -0.74V, where the potential is a value in cell B2 of the worksheet, the complete formula = Half-wave potential = B2 V must appear in the worksheet cell. 

The chart must be activated. If the chart is an embedded chart, you must activate it by clicking on it, 

With the chart as the active document, select the chart text element (Chart Title, X Axis Title, Y Axis Title or Unattached Text) by using the Chart menu or by clicking on the chart text element if it already exists in the chart. 

---