Newbie Chart problem

[LeeThailand]

Crying out for help here, I am a newbie.

I am using the following code..

Please Login or Register  to view this content.

It does everything I want, except I get the wrong chart..

capture2.JPG

My Data looks like this

Capture1.JPG

To get the chart I want, I have to right click and change chart type.

capture3.JPG

How do I get the chart I want to automatically appear (Below)? Appreciate it guys for any pointers..

Capture4.JPG

Thanks

Lee

[mohadin]

Might help
Some examples of XlChartType Enumeration:
xlAreaStacked (value 76) - Stacked Area; xlBarClustered (57) - Clustered Bar; xlBarOfPie (71) - Bar of Pie; xlBarStacked (58) - Stacked Bar; xlColumnClustered (51) - Clustered Column; xlColumnStacked (52) - Stacked Column; xlConeBarClustered(102) - Cone Bar Clustered; xlConeBarStacked (103) - Cone Bar Stacked; xlCylinderBarClustered (95) - Clustered Cylinder Bar; xlCylinderBarStacked(96) - Stacked Cylinder Bar; xlLine (4) - Line; xlLineMarkers (65) - Line with Markers; xlLineStacked (63) - Stacked Line; xlPie (5) - Pie; xlPieOfPie (68) - Pie of Pie; xlPieExploded (69) - Exploded Pie; xlXYScatter (-4169) - Scatter; xlXYScatterLines (74) - Scatter with Lines; xl3DArea (-4098) - 3D Area; xl3DColumn (-4100) - 3D Column; xl3DAreaStacked (78) - 3D Stacked Area; xl3DBarClustered (60) - 3D Clustered Bar; xl3DBarStacked (61) - 3D Stacked Bar; xl3DPie (-4102) - 3D Pie; xl3DPieExploded (70) 3D Pie Exploded; ... and so on.

[AliGW]

Thread closed in favour of Commercial Services thread.