Microsoft Office Tutorials and References
In Depth Information
Linking Chart Text to Cells
Linking Chart Text to Cells
When you create a chart, you might like to have some of the chart’s text elements linked to cells.
That way, when you change the text in the cell, the corresponding chart element is updated. You
can even link chart text elements to cells that contain a formula. For example, you might link the
chart title to a cell that contains a formula that returns the current date.
You can create a link to a cell for the chart title, the axis titles, and the data labels.
1. Select the chart element that will contain the cell link.
2. Click the Formula bar.
3. Type an equal sign ( ).
4. Click the cell that will be linked to the chart element.
In addition, you can add a linked text box to a chart:
1. Select the chart.
2. Choose Insert
Text Box.
3. Click inside the chart to add an empty text box.
4. Click the Formula bar.
5. Type an equal sign ( ).
6. Click the cell that will be linked to the text box.
Search JabSto ::

Custom Search