Copied excel chart shows hidden data after source data file closed

[Sushil]

Hi,

i copied a excel chart with source data in a different workbook. the source data had data in some hidden colums too. Copied chart looks exactly the same as the chart in the source data file. But as soon as i close the source data file, copied chart starts showing the hidden data too. is there any way this can be avoided. your help will be greatly appreciated.


Thanks

Sushil

 

[Luke M]

Does the chart need to still be linked? If not, you could change the copy to a static picture.

 

[Sushil]

Yes. chart needs to be linked so that it can be updated. Thanks.

 

[Sushil]

sorry typo.. chart*

 

[Luke M]

Copy the region of cells surrounding the chart in source workbook, and then in desintation workbook, you could paste a picture link.


In 2003:

Hold Shift, then Edit - Paste Picture Link


In 2007+

Home - Paste - As Picture, Picture Link


This will force the 2nd chart to look exactly like the chart in 1st workbook.

 

[Sushil]

Correct me if i am wrong, but pasting as a picture wont let the graph update next time . thanks

 

[prasaddn]

Hi Sushil,


On a lighter note, you underestimate our (Excel Ninja)Luke M's solution??? never dare to do it again


Well, the when picture pasted as link will get auto updated when the source changes. There are multiple ways to do this.


try this link:

http://chandoo.org/wp/2008/12/02/excel-camera-tool-help/


Regards,

Prasad DN

 

[Luke M]

=)

 

[Sushil]

Thanks.. Camera tool works perfect... Maybe i was not doing in same way earlier as Luke had mentioned. Thanks again!