MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Paste Picture Link doesn't work in charts

Posted by Tracy on September 27, 2001 9:38 AM

I have a spreadsheet that tracks each branch sales totals by month. Each branch has it's own chart. For information purposes I put the $ change by month in a text box on the chart manually. Since this information is calculated on the spreadsheet, I would like to create a link on the chart to the cell on the spreadsheet that has the info so it would be automatically updated. I thought the paste picture link would be the answer but that option is grayed out. Why? Is there another way to link a spreadsheet cell to a blank space on the chart?

Posted by Damon Ostrander on October 01, 2001 8:38 AM

Hi Tracy,

To link the text of a textbox to a cell, for example B4, simply select the textbox, then type =B4 in the formula bar input line. If B4 contains your sales total, then the textbox might contain something like $12,760.54. If you want the text box to read "Sales Total: $12,760.54", you will need to create this string in another cell. For example, using B5 for this, enter the formula in B5:

="Sales Total: " & B4

Then assign the textbox to cell B5 instead of B4.

Happy computing.