Adding linked data to charts
You can display the data from linked cells on a chart. This is useful when you use a chart type that shows information that lacks specific numeric content (for example, in a surface chart). If you select multiple cells, a linked picture of them appears on the chart. If you select a single cell, the data in that cell displays on the chart (for example, the number in the cell). The cells in the chart update with any changes you make to the data or properties of the notebook cells.
To add linked data to a chart |  |
|
1.
|
|
Double-click a chart.
|
|
2.
|
|
Click Insert
 Link to cells. |
|
3.
|
|
Click and drag a rectangle on the chart where you want the data to appear.
|
|
4.
|
|
Click the Pointer button next to the Select cells box in the Link cells dialog box, then choose the cell or group of cells you want to display.
|
|
5.
|
|
Enable one or both of the following check boxes in the Border options section:
|
|
•
|
Row borders
|
|
•
|
Column borders
|
|
6.
|
|
Enable one or both of the following check boxes in the Grid lines section:
|
|
•
|
Horizontal
|
|
•
|
Vertical
|
|
7.
|
|
Enable the Maintain aspect ratio check box in the Display scaling section to match the same aspect ratio used on the notebook.
|
|
•
|
|
You cannot select noncontiguous selections with the Link to cells tool.
|