Dynamically display the contents of a cell or range in a graphic object

To display the contents of a worksheet cell in a shape, text box, or chart element, you can link the shape, text box, or chart element to the cell that contains the data that you want to display. Using the Camera Button image command, you can also display the contents of a cell range by linking the cell range to a picture.

Because the cell or cell range is linked to the graphic object, changes that you make to the data in that cell or cell range automatically appear in the graphic object.

What do you want to do?


Dynamically display cell contents in a shape or text box on a worksheet

  1. If you do not have an shape or text box in your worksheet, do the following:
  • To create an shape, on the Insert tab, in the Illustrations group, click Shapes, and then click the shape that you want to use.

Excel Ribbon Image

  • To create a text box, on the Insert tab, in the Text group, click Text Box, and then drag to draw the text box in the text box size that you want.

Excel Ribbon Image

  1. On the worksheet, click the shape or text box to which you want to link the cell contents.
  2. In the formula bar, type an equal sign (=).
  3. Click the worksheet cell that contains the data or text that you want to link to.

 Tip   You can also type the reference to the worksheet cell. Include the sheet name, followed by an exclamation point; for example, =Sheet1!F2.

  1. Press ENTER.

The contents of the cell is displayed in the shape or text box that you selected.

 Note   You cannot use this procedure in a scribble, line, or connector shape.

Top of Page Top of Page

Dynamically display cell contents in a title, label, or text box on a chart

  1. On a chart, click the title, label, or text box that you want to link to a worksheet cell, or do the following to select it from a list of chart elements.
  1. Click a chart.

This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  1. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.

Excel Ribbon

  1. In the formula bar, type an equal sign (=).
  2. In the worksheet, select the cell that contains the data or text that you want to display in the title, label, or text box on the chart.

 Tip   You can also type the reference to the worksheet cell. Include the sheet name, followed by an exclamation point, for example, Sheet1!F2

  1. Press ENTER.

The contents of the cell is displayed in the title, label, or text box that you selected.

Top of Page Top of Page

Dynamically display cell range contents in a picture

  1. If you haven't already done so, add Camera Button image to the Quick Access Toolbar.
    1. Click the arrow next to the toolbar, and then click More Commands.
    2. Under Choose commands from, select All Commands.
    3. In the list, select Camera, click Add, and then click OK.
  2. Select the range of cells.
  3. On the Quick Access Toolbar, click Camera Button image.
  4. Click a location on a worksheet or chart where you want the picture of the cell range inserted.

The contents of the cell range is displayed in the picture.

  1. To format the picture or do other operations, right click the picture and choose a command.

For example, you may want to click the Format Picture command to change the border or make the background transparent.

Top of Page Top of Page

 
 
Applies to:
Excel 2010, Excel 2007