Archive of Mr Excel Message Board
|Check out our Excel Charting Resources
Back to Charting for Excel archive indexBack to archive home
Paste Picture Link doesn't work in chartsPosted 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 chartsPosted by Damon Ostrander on October 01, 2001 8:38 AM
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.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
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.