how to set the source data range for chart in code?

[xq]

i have one blank column B, and i don't want it appears in chart, how do i do it?

that's the code i've written, but it didnt' give me what i want.
Charts(1).SetSourceData Source:=Sheets(1).Range("a1:d10), _
PlotBy:=xlColumns

thanks a lot !

 

[xlbo]

try this (untested)
Charts(1).SetSourceData Source:=Sheets(1).Range("a1:a10,c1:c10&quot, _
PlotBy:=xlColumns
Rgds
Geoff