Hi,
I have come across a wierd problem. I have a macro in excel which
generates charts after reading from various excel sheets. So i am
running a loop to read the excel file name and then generate the chart.


To generate the chart, I set the source of the chart to the read excel
file like this:

ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("F1:G1486"),
PlotBy _
:=xlColumns

Now, this works correct. But now, in the same range of sheet1, i copy
some other data and try to genarate a chart from the new data. But
because i have set the source of the previous chart to the same range,
that chart changes as well.

So is there some way to stop that chart from changing or decoupling the
chart from that range of data. Because i dont want to create a new data
sheet for every chart i make.

Please do let me know,
Thanks,
Snigdha


--
snigdha
------------------------------------------------------------------------
snigdha's Profile: http://www.excelforum.com/member.php...o&userid=27370
View this thread: http://www.excelforum.com/showthread...hreadid=468844