P poojaryg New Member Jan 17, 2013 #1 In one of the Dashboard I show that, in sheet1 there was screen clip of main chart available on sheet 2, and when ever I make any changes to main chart, screen clips also (sheet1) get change. please help me in understaning how it is possible.
In one of the Dashboard I show that, in sheet1 there was screen clip of main chart available on sheet 2, and when ever I make any changes to main chart, screen clips also (sheet1) get change. please help me in understaning how it is possible.
Hui Excel Ninja Staff member Jan 17, 2013 #2 Poojaryg Firstly, Welcome to the Chandoo.org Forums It sounds as if your file has a Camera Tool object in it A camera Tool can transfer an image of a Range of Cells to another location as if taken by a camera The camera is dynamic and updates as the data, chart in your case, changes Refer: http://chandoo.org/wp/2008/12/02/excel-camera-tool-help/
Poojaryg Firstly, Welcome to the Chandoo.org Forums It sounds as if your file has a Camera Tool object in it A camera Tool can transfer an image of a Range of Cells to another location as if taken by a camera The camera is dynamic and updates as the data, chart in your case, changes Refer: http://chandoo.org/wp/2008/12/02/excel-camera-tool-help/