Software

Ask something
Discussion Locked

Excel Charts and paste picture link

0 helpful
3 replies

by tracyp

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

3 replies

by dklippert

Works for me. First I added the camera icon from Tools>Customize - Commands>Tools.
I chose the cell and clicked the icon. I then clicked on the chart. If the chart is an object on the spreadsheet, you may have to use Draw to move the picture Order

This discussion is closed to new replies.