Thread: break a link
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
see:
http://www.peltiertech.com/Excel/Cha...html#DelinkCht

--
Regards
Frank Kabel
Frankfurt, Germany
"refresh" schrieb im Newsbeitrag
...
Hiya,

Is there an easy way to unlink a chart from its source data? I have 6
charts generated from a large spreadsheet in excel 97. I send these
charts
on by email to others and I want to be able to send the charts without the
links to keep the file size reasonable.

I tried copy, paste special, paste as picture but the paste special box is
greyed out. I can copy into word using paste special but not within excel
which seems a little bit strange. It also leaves me with formatting
problems
I'd like to avoid.

Thanks for your help.