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 updated automatically. I thought the paste picture link would be the answer but that option is grayed out. Why? Is there another way to linka spreadsheet cell to a blank space on the chart?
