Excel Charts

[Hannibal]

I have a chartobject that i want to apply a built-in custom type to. I have tried:
<SNIP>
new_chart.Chart.SetSourceData Source:=Sheets(wkname).Range(temp), _PlotBy:=xlColumns
</SNIP>
but it seems to just default to a bar type. Any suggestions? Thanks for your help.