Did the line you posted actually work? I was assuming it did....

You could always try

dim sName as string

sName = activesheet.name

ActiveChart.SetSourceData _
Source:=Sheets(sName).Range("A1:B400"), _
PlotBy :=xlColumns

Tim

"Losse" wrote in
message ...

That only gives me an error. It tells me "Object doesn't support
this
property or method." I belive there needs to be an "_" after the
PlotBy
as well.


--
Losse
------------------------------------------------------------------------
Losse's Profile:
http://www.excelforum.com/member.php...o&userid=24813
View this thread:
http://www.excelforum.com/showthread...hreadid=383681