Camera Tool doesn't work

[Vanessa Tu]

When I use camera tool in Excel to copy a chart, I follow instruction carefully but the picture only shows part of the chart. How can I fix it?

 

[sandy666]

Camera Tool doesn't work with chart
Copy chart - Paste Special - Microsoft Office Drawing Object

 

[Vanessa Tu]

Hi Sandy if I use copy and paste microdot office drawing object, will it reflect the changes I will make in original data and chart? Your advice is appreciated.

 

[Vanessa Tu]

Hi Sandy, I just follow your advice, but the copy and paste as microdot office drawing object doesn't include my red rectangular shape with my note "Budget risk", hence I thought by using camera, it will take it as a photo and include everything.
When I use camera, it relates to correct cell range of the chart and there is not hidden column or row nor is there any merged cell range, but the photo only shows half of the chart.

 

[Vanessa Tu]

Sorry to include my chart for your information.

​

 

[sandy666]

Hard to imagine what are you tryin' to do
but try select chart and with ctrl key select shape then copy and paste as MS Drawing object

 

[sandy666]

maybe share link to desensitized example excel file with your problem

 

[sandy666]

btw. you've full inbox. clean it if you want any answer

 

[Vanessa Tu]

Hi Sandy, I don't know how share link to desensitized excel file with source data andexpected result , can you please send me an email using my address vanessattu@gmail.com I find this email box is unfriendly it is hard to navigate. Thanks

 

[sandy666]

use OneDrive or GoogleDrive and share link to the file from there (or tinyupload.com)
I think you shouldn't post email address here