General discussion

Locked

Excel Charts and paste picture link

By tracyp ·
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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Charts and paste picture link

by DKlippert In reply to Excel Charts and paste pi ...

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<Bring to Front.

Collapse -

Excel Charts and paste picture link

by tracyp In reply to Excel Charts and paste pi ...

Thanks a lot, that one stumped me.

Collapse -

Excel Charts and paste picture link

by tracyp In reply to Excel Charts and paste pi ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums