A link to a cell can be made in PlanMaker for Text frames, AutoShapes and also certain chart elements (chart title, axis title). This enables you to transfer the contents of a cell – for example, the result of a calculation – to an object for illustration purposes.
Note: This only works if there is no text in the object. Thus, delete existing text from the object beforehand.
The cell contents are displayed dynamically. So if the linked cell is overwritten with new data, the corresponding content will also change in the object.
Proceed as follows:
| 1. | Click on the frame of an object to select it. |
| (For chart elements, proceed differently. For more information, see chapter Chart title, Axis title) |
| 2. | Choose the command Add/edit link  on the contextual ribbon tab Object | group Inner text. |
| Alternatively: Right-click on the frame for the context menu, select Link to a cell. |
| 3. | A dialog box opens. Now click directly in the document on the cell whose content is to be displayed in the selected object. Alternatively, you can type the cell address into the input field of the dialog box (for example, "=Table1!A1"). |
| Tip: It is also possible to link to cells on another worksheet in the document. |
| 4. | Click on Add. |
The cell content of the selected cell is now displayed in the object. If the object is selected, you will see the cell address that is linked to the object in the Edit toolbar.
If you want to change the font or alignment of the displayed text, select the object and use the commands on the ribbon tab Home | group Character/Alignment or on the ribbon tab Object | group Inner Text.