Hamond
06-16-2009, 05:31 AM
Hi,
I've serached the net but could not find anything on this.
Is there a way in to copy chart from one sheet into another sheet without the links or break the links once the chart is in the other sheet?
For example I want to copy the range N1:R100 from sheet X to Sheet Y. Part of this range as two chart based on the data (columns b, c and d) in sheet X. In sheet Y I just want the image/pciture, i.e don't want the chart to update when data in sheet X changes.
Thanks,
Hamond
I've serached the net but could not find anything on this.
Is there a way in to copy chart from one sheet into another sheet without the links or break the links once the chart is in the other sheet?
For example I want to copy the range N1:R100 from sheet X to Sheet Y. Part of this range as two chart based on the data (columns b, c and d) in sheet X. In sheet Y I just want the image/pciture, i.e don't want the chart to update when data in sheet X changes.
Thanks,
Hamond