Adding a Linked Picture to a Chart in Microsoft Excel

It would be an understatement to say that it is simple to update text in an object.
Let’s say, for example, that you add a title to the chart to indicate the period of the statement. A month later, the period of the financial statements changes, and you find yourself fighting to change the text in the object you have pasted into the chart.
When you link an object to a cell in the sheet, any change to the text in the cell will automatically update the text in the object.

Creating a picture of cells that is linked to the source data
In the sheet, copy a cell or cells that contain text or data, and paste it into the chart. Hold down Shift, and click Paste Picture Link on the Edit menu.
-OR-
Select a cell or cells, click the Camera icon, and then click where you want to paste the upper-left corner of the picture.
.
Adding the Camera icon to the toolbar
Right-click any toolbar. From the shortcut menu, select Customize. Select the Commands tab, and from the Tools category, click and drag the Camera icon onto the toolbar.

Guidelines for working with linked pictures
Formatting – The linked text in the picture is formatted according to the formatting in the cell. Any changes to the formatting must be done in the source cell. You can change the formatting of the text; add text wrapping; change the width of a column or cell; omit gridlines (From the Tools menu, select Options, select the View tab, and then clear the Gridlines checkbox); and change the font color and cell shading (background color).

Note
Be sure to resize the column containing text you want in the picture before creating the link. Only the visible information in the cell will be included in the picture.

In the screen shot, two pictures have been pasted into a chart: a picture of the data table and a picture of the chart title.
The text, Sales Report for 3 years, was typed and formatted in a single cell in a different sheet.

Screenshot // Adding a Linked Picture to a Chart in Microsoft Excel