Microsoft Office Tutorials and References
In Depth Information
Creating Links to Cells
The result is a formula that contains the sheet reference and the cell reference as an absolute
reference (for example, =Sheet1!$A$1). Figure 17-3 shows a chart in which the chart title is linked to
cell A1 on Sheet3.
Figure 17-3: The chart title is linked to cell A1.
Adding axis title links
The axis titles are optional and are used to describe the data for an axis. The process for adding a
link to an axis title is identical to that described in the previous section for a chart title.
Adding links to data labels
You probably know that Excel enables you to label each data point in a chart. You do this by
using Chart Tools
Data Labels. Unfortunately, this feature isn’t very flexible.
For example, you can’t specify a range that contains the labels.
You can, however, edit individual data labels. To do so, click any data label to select them all, and
then click a second time to select the single data label. When a single data label is selected, you
can add any text you like. Or, you can specify a link to a cell by typing an equal sign and clicking
a cell to create a reference formula (such as =Sheet1!$A$1).
Adding text links
You can also add a linked text box to a chart. The process is a bit tricky, however. Follow these
1. Select the chart and then choose Insert
2. Drag the mouse inside the chart to create the text box.