"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

Similar Threads

Help: Chart & data 1
Paste Excel chart in Powerpoint - how to "send to back" the pasted chart 1
"Breaklink Problem" 2
Transpose & reorg data from 2 WS to new WB 2
Move one ws to new wb. Save new Wb with same but modified name as original WB 2
Problems with setting .Values with vba 3
How to change chart properties. 2
chart to email 3

Top