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?