If your worksheet was called Summary and the chart was called Chart 9
the example below shows a template for how to define the range:

Sheets("Summary").ChartObjects("Chart 9").Chart.SetSourceDat
Source:=Range("your_range_here"), PlotBy _
:=xlColumns

You can get the syntax for the range by copying the range data from th
chart controls when you update it manually. You can also add variable
to the range to expand it dynamically

--
dazma
-----------------------------------------------------------------------
dazman's Profile: http://www.excelforum.com/member.php...fo&userid=2590
View this thread: http://www.excelforum.com/showthread.php?threadid=39907