» 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
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
Ė 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).
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|