graph in chart window

**mambo** · 09-15-2009, 05:52 AM

Hi,

I have plotted a graph in a worksheet (say Sheet1), I want if I click on a button in Sheet2, the graph in Sheet1 will appear in Sheet2 (possible in a chart window) , how could I do that? please advise.

**Andy Pope** · 09-15-2009, 06:53 AM

Do you want to do anything with the chart when it appears on sheet2? If not you could use the camera tool to link a live picture.

**mambo** · 09-15-2009, 10:23 AM

Originally Posted by Andy Pope

Do you want to do anything with the chart when it appears on sheet2? If not you could use the camera tool to link a live picture.

No, I would not do anything with the chart, just want to show the graph. what you mean by camera tool?

**Andy Pope** · 09-15-2009, 11:02 AM

The camera tool allows you to create a live picture of an area.

Select the area around the chart. Hold the shift key and use menu Edit>Copy Picture.

Goto sheet2 and paste.
In the formula bar enter
=VIEW

The named range VIEW will return the cell area covered by the names YES_CHART or NO_CHART