Archive of Mr Excel Message Board

Check out our Excel Charting Resources
Back to Charting for Excel archive index
Back to archive home

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?

Re: Paste Picture Link doesn't work in charts

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.


This archive is from the original message board at
All contents © 1998-2004
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.