"Saving Chart to New WB?"

D

Don

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
 
V

Vasant Nanavati

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

Don

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

Vasant Nanavati

You are most welcome, Don!
_______________________________________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top