When you have a larger dataset and you want to export an image from the particular cell values, a linked picture might be the best option. As the linked picture will be changed automatically if you change any cell values. In this guiding session, I’ll demonstrate 4 ways to link a picture to a cell value in Excel with proper explanation.
How to Link Picture to Cell Value in Excel: 4 Methods
Let’s introduce today’s dataset where Sales of some Products are provided for two years i.e. 2020 and 2021 showing the Yearly Sales Variation. The entire dataset including the heading is available in the B4:D13 cell range.
Now, you’ll see the ways of linking the picture to the values of the B4:D13 cell range.
In the beginning method, I’ll show you the simple but effective paste options i.e. Linked Picture from the Paste Special option.
➤ To utilize the paste option, you have to select the B4:D13 cell range first and select any cell where you want to get the linked picture (e.g. F4 cell).
➤ Then, right-click and move the cursor over the rightwards arrow of the Paste Special option and pick the Linked Picture under the Other Paste Options feature.
Immediately, you’ll get a linked picture in the F4 cell as shown in the following screenshot. If you look closely at the formula bar, you’ll get =$B$4:$D$13 which represents the cell values of the Yearly Sales Variation.
Notably, this linked picture is not static, which means if you change any value in the original cells you’ll find the changed image.
For example, if you input the data of the Webcam product after removing the data of the TV, you’ll get the newly added product in the linked picture.
2. Applying the Camera Tool to Link Picture to Cell Value in Excel
In addition, you may also utilize the Camera tool instead of using the Linked Picture paste option.
Most probably, you’ll not find the feature in Excel by default. But you can add it if you want. For this, you have to right-click on the ribbon and choose the Customize the Ribbon option.
Next, you’ll see the dialog box namely Excel Options. Please follow the steps.
➤ Initially, click on the New Group and create a New Group (Custom).
➤ After doing that pick the All Commands and find the Camera command. Finally, click on the Add.
Eventually, you’ll see the added command in the Insert tab as shown in the following screenshot.
Right now, select the B4:D13 cell range and pick the Camera tool.
Later, drag down the cursor following the plus sign located on the right side.
Immediately, you’ll see the created picture that links with the raw data e.g. Yearly Sales Variation.
What if you want to get the cell value by clicking over an image? Let’s say, you have an image in your working sheet.
To link a particular cell with this picture, you have to choose the Link option from the Insert tab while selecting the image.
Shortly, you’ll get a dialog box namely Insert Hyperlink, and choose the Link to option as Place in This Document. Next, type the cell (e.g. B5) that you want to link while selecting the active working sheet i.e. Hyperlink.
After pressing OK, your existing image is linked with the specified cell. After clicking on the image, it shows the B5 cell representing the url of ExcelDemy.
Read More: How to Insert Picture in Excel Using Formula
4. Link Picture to Cell Value Dynamically in Excel
In this method, you’ll explore the process of linking the picture with the cell value dynamically. Please follow the step-by-step process.
Step 01: Insert the Pictures
Assuming that you have Logo pictures of some Social Media service as shown below screenshot.
For your convenience, I am showing the process of inserting images in Excel.
➤ Firstly, select a cell and click on the This Device command which can be added by using the Customize the Ribbon option.
➤ After adding the images, go to the Format Picture option (right-click or go to the right side of your spreadsheet). Then, check the circle before the Don’t move or size with cells option. Later, adjust the row height and width of the cells according to the size of the picture.
Step 02: Define the Names
Using the Name Manager tool, you can easily define the names of social media companies with their corresponding logo. After selecting the B5:C7 cell range, pick the option Create from Selection. And keep the box before the Left column is checked.
Step 03: Create a Drop-Down List
To make the selection more interactive, you may create the drop-down list using the Data Validation tool. Choose the Data Validation tool from the Data tab while keeping the cursor over the E5 cell.
Subsequently, you’ll see the following dialog box. So, choose the List from the drop-down list of the Allow option and set the Source as $B$5:$B$7 and press OK.
Then, you’ll get an interactive drop-down list as shown in the below screenshot.
Step 04: Paste the Picture
Right now, paste any picture from the C5:C7 cell range using the Link Picture paste option as shown in the first method. Remember, this picture is not dynamic.
Step 05: Utilizing the INDIRECT Function to Link
For making the pasted picture dynamic, you need to apply the INDIRECT function which returns the cell values defined by any text string.
So, open the Name Manager again and click on the New option to create a new defined named range.
Next, specify the Name as Logo and insert the following formula in the space after the Refers to option.
Here, the ‘Dynamic Link’ is the current sheet name and $E$5 is the name of any Social Media.
Again select the pasted picture and insert the following formula in the formula bar.
Finally, your picture is linked dynamically. If you choose any option from Social Media, the picture will be changed automatically.
Here, I selected Facebook, and the picture in the F5 cell is changed automatically.
Download Practice Workbook
That’s the end of today’s session. From the beginning to the end, I discussed the 4 ways to link a picture to a cell value in Excel. I strongly believe this article will be highly beneficial for you. Anyway, if you have any queries or recommendations, please share them in the comments section below.