Excel: Display cell value in a graph object (shape, textbox, picture, chart)
Sometimes, we need to add the contents of a cell or a range to a graph object such as adding cell contents to a shape, a picture, or a title on a chart in Excel. Here this tutorial introduces the methods for solving this job.
Note: the methods provided in this tutorial are tested in Excel 2021, there may be some different in different Excel verisions.
1. Insert a shape by clicking Insert > Shape in Illustrations group, selecting one shape from the expanded menu.
Note: Inserting textbox by clicking Insert > Textbox in Text group.
2. Then drag the cursor to draw the shape or textbox in current worksheet.
3. Then keep the shape or textbox selected, go to the formula bar, type the equal sign (=).
4. After typing the equal sign, select a cell or a range of cells that you want to display in the shape or textbox, then press Enter key.
Now the cell contents have been displayed in the shape or textbox, and it is changed as the cell contents changed.
Notice that if you want to refer to a sheet cell, you need to add the sheet name followed by an exclamation point such as Sheet1!A2.
1. Click on the chart that you want to display cell value in its title, then go to the Chart Design tab.
2. Click Add Chart Element > Chart Title, then choose one type of titles you want to insert.
3. Then select the title, go to the formula bar, type the equal sign (=), and select the cell(s) that you want to display the contents.
4. Press Enter key, now the contents of the specified cell(s) have been displayed in the chart title.
If you want to display the cell contents as a picture as the below screenshot shows, you need to add the Camera tool to the Quick Access Toolbar firstly.
1. Enable Excel, click File > Options to enable the Excel Options window.
2. Click Quick Access Toolbar from the left pane, then go to the right section, choose All Commands from the drop-down list of Choose commands from section, then scroll the scroll bar to find Camera command, click it and click Add button to add into the Custom Quick Access Toolbar section. Click OK.
Now you can see the Camera command has added in the Quick Access Toolbar.
3. Select the cell(s) that you want to display in a picture, then click Camera button, then press Enter key. Now the selected cells have been shot as a picture.
Note that the contents in a picture will be changed as the cell contents change.