Hi i am trying to move a chart in to a different workbook. now by doing
this the chart i get in the new workbook is the reference to my
previous workbook. so any chages in the table is reflected in both the
charts. Which i dont want. i just want it to reflect in the current
worksheet and not in the new workbook.

can someone suggest what shud i do..