paste values with graphs

[Guest]

I have a spreadsheet with tables and graphs and would like to send them out
so that people get the data but not all the formulae, and get the data as it
is when I send the spreadsheet out.

Is there any easy way to copy and special the whole lot? So far I can only
copy and paste special values on the tables. The graphs do not get copied and
when I copy them seperately they remain linked to the original.

Any suggestions would be great.
Thanks!

 

[Andy Pope]

Hi,

Have a read of Jon Peltier's page on the matter.
http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

Cheers
Andy

 

[Jon Peltier]

Or copy the chart as a picture (Shift + Edit menu > Copy Picture, use On
Screen and Picture options) and paste it into the copied sheet.

- Jon