"Saving Chart to New WB?"

[Guest]

Hi There,

I've got several worksheets's that contain charts. The charts draw data
from different sheets in the same WB. Is there a way to save just a chart to
a new workbook, eliminating the links and retaining the chart as viewed in
the original workbook. I've done this with WS's using the copy/paste
special method but that doesn't seem to be an option that's available for
charts.

TIA,

Don

 

[Vasant Nanavati]

Copy and Paste (not Paste Special). Then use Edit | Links | Break Links.
________________________________________________________________________

 

[Guest]

Thank you very much Vasant..appreciate the very quick response...works like a
charm...tks again... Don

 

[Vasant Nanavati]

You are most welcome, Don!
_______________________________________________________________________